I want to refer to a range on a worksheet that will be dynamic (it will be added to over time) I defined a variable (rng as Range) and want to refer that to the data. How do I set the rng variable to be all of that data to be used in a vlookup?
ex. If I select A1 and use the Currentregion.select, can I then name that currentregion and then use that name in the vlookup? How would I refer to the name of the range?
thanks
Bookmarks