how to drag vlookup in vba for all the cells down with dynamic range

how to drag vlookup in vba for all the cells down
I have written

 
     Cells(4, Newcolumn).Formula = Application.WorksheetFunction.VLookup(Range("A4"), Sheets("Basic_Data").Range("C2:J7129"), 8, False)

Selection.AutoFill Destination:=Cells(newrange & ":" & r & "7129")
 Range(newrange & ":" & r & "7129").Select

but this is copying only values not formula. I need to use dynamic range
Ruchi_SasAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
gamarrojgqConnect With a Mentor Commented:
Hi,

Try it like this

Cells(4, Newcolumn).Formula = "=VLOOKUP(A4,Basic_Data!$C$2:$J$7129,8,False)"
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.