Advertisement
Guest User

Untitled

a guest
Jul 26th, 2017
67
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.56 KB | None | 0 0
  1. Sub testEval()
  2.  
  3. Dim dataTable As ListObject
  4. Dim evalStr As Variant
  5. Dim item1 As String
  6. Dim item2 As String
  7. Dim ws As Worksheet
  8.  
  9. item1 = "Orange"
  10. item2 = "Feb"
  11.  
  12. Set ws = ActiveSheet
  13. Set dataTable = ws.ListObjects("myTable")
  14.  
  15. With ws
  16.  
  17. 'V1
  18. evalStr = .Evaluate("MATCH(" & item1 & "&" & item2 & "," & .Columns(1).Address & "&" & .Columns(2).Address & "),0)")
  19.  
  20. 'V2?
  21. 'evalStr = .Evaluate("MATCH(" & item1 & "&" & item2 & "," & Application.WorksheetFunction.Substitute(.Columns(1).Address & "&" & .Columns(2).Address, "$", "") & "),0)"
  22.  
  23. End With
  24. End Sub
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement