VBA code to paste formula in range not working

[shailesh.kumbhar]

Hi,

I have a formula in cell A2, I am trying to paste the formula till last row with data in column B. Trailing is the code that i am trying.


Sheets("master").Activate
ActiveSheet.Range("a2").formula = "=VLOOKUP(b2,Input!$K$11:$K$65536,1,0)"
Sheets("master").Range("a2").AutoFill Destination:=Range("a2:a" & Cells(Rows.Count, 2).End(xlUp).Row)

Where am i going wrong ?

 

[VoG]

Does this work

Sheets("master").Activate
LR = Range("B" & Rows.Count).End(xlUp).Row
Range("A2:A" & LR).Formula = "=VLOOKUP(b2,Input!$K$11:$K$65536,1,0)"

 

[shailesh.kumbhar]

Hey VoG

Thanks a ton!..you saved my hairs going off my head. So simple but yet so complicated.

Thank you again for your time !