Vlookup in a Macro

[Spinz]

Hi

I have the following vlookup formula and wish to insert this into a macro

the worksheet has the vlookup field in column "e" with month by month data
going across in columns - these will be updated monthly from a downloaded csv

the vlookup looks like this

VLOOKUP(RC[-11],'Filename'!R33C3:R84C12,10,0

-11 = column e

Does anyone know how i can make this formulae stretch down as far as i need
it to go down ?

Thanks in advance

 

[Spinz]

Hi

It is coming back with runtime error 424 - any ideas ?