Vlookup using VBA

[pdalal]

I have a vba code that I am working on and my challenge is that after I open all the files I need and write the VBA code I am specifying a cell where that vlookup is:
This is what I have :

This brings in the vlookup in AF2 and AG2 Now i need it to find the last row and copy the formula down to all the cells.
How can I do that? Ideally I dont want to specify a ending row like i have done in the formula since it will give #N/A on extra empty rows.

Thanks for your help!

[pdalal]

Code Tags applied

[Arkadi]

pdalal,
You don't want to specify an ending row because of empty rows... but what if you use a variable for the last row? Then you can assign that variable the value of the last row with data, and used that row in your code. The code line below would find the last row that has data in it, change sheet name to the right one, and change the column (A) to whatever column would be populated.

Please Login or Register  to view this content.

[pdalal]

how would I put that in my vlookup to copy all the way down in range AF and AG and also add if is NA then just leave as ""

[Arkadi]

lets stick to one thread... I've replied in the other, which had other activity, so I'll stay on that one and abandon this one.

[alansidman]

Welcome to the Forum, unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.