VBA - VLookup on different sheet

[65bit]

Hi,

I'm fairly new to VBA and can't figure this out. I'm stepping through rows on sheet 1 and (along with many other things) using vlookup to grab a value from sheet 2 ("ShiftMaster"). When I hardcode a range variable like below, and use it in the vlookup function, all works fine:

Please Login or Register  to view this content.

Since the range may grow over time, I need to add a little smarts to allow for that. I did the below to determine the number of rows in the range

Please Login or Register  to view this content.

But, when I try to change from the hardcoded range above to one using "cells" so I can utilize the xRow var (like below), I continually get a 1004 - application defined object error

Please Login or Register  to view this content.

I've looked at other approaches to allow for a dyanmic range, but I error out on them as well

Any input would be appreciated!

Thanks,
David

[rylo]

David

Try something like

Please Login or Register  to view this content.

HTH

rylo

[65bit]

Rylo - thanks!! That works great. I'll do a little digging to understand the difference in the two approaches.

Thanks again