Making vlookup dynamic by using lastrow and lastcol

[ramakriishna]

How to make vlookup dynamic by using lastrow and lastcol


vba code

sub vlookup

lastrow=12

lastcol=11

activecell.formular1c1="="vlookup(RC[-1],sheet2!r1c1:R"&lastrow&"C"&lastcol,column(c[2]),false""

i want write vlookup like above while assing &lastrow and &lastcol

it is giving error

how to assign &lastrow and &lastcol to above formula

any help

Thanks in advanced

 

[shrivallabha]

You can record macro while implementing the formula and then edit it to make dynamic.


That said try following [untested]:

ActiveCell.FormulaR1C1 = "=VLOOKUP(RC[-1],Sheet2!R1C1:R" & lastrow & "C" & lastcol & ",COLUMN(RC[2]),FALSE)"