Need code to enter the last cell when using VLOOKUP

**Footley** · 08-24-2012, 09:54 PM

I need the following code modified so the lookup range is dynamic. The next file may not be the same size.
The first line is how it appears in the cell.
The second line is in the VBA code.
All data will be in columns A and B but the number of rows changes.

Please Login or Register  to view this content.

**jeffreybrown** · 08-24-2012, 10:19 PM

Try

Please Login or Register  to view this content.

**Footley** · 08-24-2012, 11:19 PM

The code you provided limited the lookup to two rows from A1 to B2. I expected a range from A1 to B356 which is the required data set to scan.

**JapanDave** · 08-24-2012, 11:45 PM

Footley, Not to step on Jeffs toe's (he certainly can give the same answer), but Jeff's code is sound, it will dynamically change the range to suit.
Do you only have two rows with data in them in column A an the worksheet you ran the code on?

**jeffreybrown** · 08-25-2012, 08:24 AM

@JapanDave -- the more help the merrier

@Footley,
My fault, should have qualified the LR variable as you most likely ran this code from a sheet other than the Order tab. In this case, if the LR variable is not qualified then the LR was taken from the active sheet.

This should be more accurate

Please Login or Register  to view this content.

**Footley** · 08-25-2012, 02:13 PM

Thanks for your input. I should have said the lookup data was not on the same tab. The whole process I'm building is to take information from SAP to Excel, build a file that can then be loaded into MS Project with a minimum of manual computer time. I'm now two steps closer after joining this forum.

Thanks to others for viewing my request.