VBA Formula Question

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

Hi Barb,

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

--
Kind regards,

Niek Otten

"Barb Reinhardt" <[email protected]> wrote in message
news:[email protected]...
>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

Without the linebreak of course

--
Kind regards,

Niek Otten

"Niek Otten" <[email protected]> wrote in message
news:u94F%[email protected]...
> Hi Barb,
>
> "=VLOOKUP(RC7,WorksheetPivot!R3:R" & lrow &
> ",MATCH(R1C,WorksheetPivot!R2),FALSE)"
>
> --
> Kind regards,
>
> Niek Otten
>
> "Barb Reinhardt" <[email protected]> wrote in
> message news:[email protected]...
>>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
>
>

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

"Niek Otten" wrote:

> Hi Barb,
>
> "=VLOOKUP(RC7,WorksheetPivot!R3:R" & lrow &
> ",MATCH(R1C,WorksheetPivot!R2),FALSE)"
>
> --
> Kind regards,
>
> Niek Otten
>
> "Barb Reinhardt" <[email protected]> wrote in message
> news:[email protected]...
> >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
>
>
>