Hi All,
May I ask assistance on this?
this code gives me "Run-time error '1004:"
May I ask assistance on this?
this code gives me "Run-time error '1004:"
Code:
Application.WorksheetFunction.Index(Sheets("Sheet1").Range(NameRange1), Application.WorksheetFunction.Match("Hello", Sheets("Sheet1").Range(NameRange2), 0) - 1)
this works well:
[CODE]
Application.WorksheetFunction.Index(Sheets("Sheet1").Range("D1:D100"), Application.WorksheetFunction.Match("18-1113095", Sheets("Sheet1t").Range("A1:A100"), 0) - 1)
Reason I need to put a name range or variable is I need to have constantly changing ranges.
Much thanks,
reggieneo