I am trying to automate the formatting of a spreadsheet into a new format.

I nee to add a vlookup into a range that is going to change each time I run
it.

The formula in cell E3 will look like this -
=vlookup(A3,A500:Ee3000,5,false), where the 500:3000 is actually unknown each
month.

Once the formula is written it need sot be copied down to cell E499, or
whatever that cell will be but I got that covered. I just need know how to
have the data range by dynamic.

I tried using firstdatacell and lastdatacell but couldn't figure out how to
work that into the Vlookup formula.

Also one quick reminder.

When I want to go down then across a couple of rows I tried

activecell.end(xldown).offset(0,2).select

but it isn't working have I got something wrong?

Thanks in advance
Rick