Hi, the code below returns error 1004. And when I replace "myRange" at the vlookup line with "a1:g4" it works. What's wrong with my code?
Dim myRange As Range
Set myRange = Sheets(1).Range(Cells(1, 1), Cells(i, j))
Dim Result As String
Result = Application.VLookup(Range("J4"), Range("myRange"), 1, False)