VBA Formula Question

[Barb Reinhardt]

I have the following

ActiveCell.FormulaR1C1 = _

"=VLOOKUP(RC7,WorksheetPivot!R3:R7,MATCH(R1C,WorksheetPivot!R2),FALSE)"

I want to change R7 to be variable based on the number of rows in the
worksheet. I have a value for that which I'll call "lrow". What do I need
to do to change the R3:R7 to R3:R &lrow?

Thanks,
Barb Reinhardt

 

[Niek Otten]

Hi Barb,

"=VLOOKUP(RC7,WorksheetPivot!R3:R" & lrow &
",MATCH(R1C,WorksheetPivot!R2),FALSE)"

 

[Niek Otten]

Without the linebreak of course

 

[Barb Reinhardt]

Thanks, I'll try that. I wasn't sure if I could do it that way.