Currentregion and/or range naming

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

Yes, that works. Now how do I refer to that in the vlookup? as a test, I set a static range and called it "events". From my main sheet, I want to do a vlookup on that data and I plugged in the following:

ActiveCell.Formula = "=if(iserror(vlookup(F4,(events),8,false)),"",vlookup(F4,(events),8,false))"

I get a runtime 1004 application-defined or object-defined error

Do I have to activate the sheet where the "events" range is resident before running that line?

Sorry about that. I stepped through it and it ran without an error.

thanks