Hi All,
I've read about 60 post and still no luck!
I need to run a VLookUp via VBA.
Currently using this:
Note:Cell T10 and D10 are in Worksheet "WebDrop"
and A2-K10000 are in "Airports...
T10=VLOOKUP(D10,Airports!$A$2:$K$10000,8,FALSE)
Which I copied from T10.... T1500, my range varies daily between 600-1200 rows and my array table might increase one day...so I want to capture a type of 65536.End(xlUp) formula
Now, in VBA I want something like this...
Do use it, it's just a free flow example..
I've tried about 10 codes plus many modification, I'm losing it!
--------------------
Sub helpPlease()
Sheets("WebDrop").Selects ' need this line, do to previous macros...
With T10:T65536.End(xlUp) ' need my results in these cells
Formula."=vlookup(WebDrop!D10:D65536.End(xlUp),Airports'!A2:K10000,8,False)"
'want to change A2:K10000 to K65536.End(xlUp) if possible..
End With
End Sub
-------------------------
Any other approach are welcomed...
Cheers,
Sprucy
I've read about 60 post and still no luck!
I need to run a VLookUp via VBA.
Currently using this:
Note:Cell T10 and D10 are in Worksheet "WebDrop"
and A2-K10000 are in "Airports...
T10=VLOOKUP(D10,Airports!$A$2:$K$10000,8,FALSE)
Which I copied from T10.... T1500, my range varies daily between 600-1200 rows and my array table might increase one day...so I want to capture a type of 65536.End(xlUp) formula
Now, in VBA I want something like this...
Do use it, it's just a free flow example..
I've tried about 10 codes plus many modification, I'm losing it!
--------------------
Sub helpPlease()
Sheets("WebDrop").Selects ' need this line, do to previous macros...
With T10:T65536.End(xlUp) ' need my results in these cells
Formula."=vlookup(WebDrop!D10:D65536.End(xlUp),Airports'!A2:K10000,8,False)"
'want to change A2:K10000 to K65536.End(xlUp) if possible..
End With
End Sub
-------------------------
Any other approach are welcomed...
Cheers,
Sprucy