Ruchi_Sas

asked on

# 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

I have written

Cells(4, Newcolumn).Formula = Application.WorksheetFunct

Selection.AutoFill Destination:=Cells(newrang

Range(newrange & ":" & r & "7129").Select

but this is copying only values not formula. I need to use dynamic range

ASKER CERTIFIED SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Open in new window