Link to home
Start Free TrialLog in
Avatar of Jagwarman
Jagwarman

asked on

VBA to copy down without incrementing numbers

I am usiing the below code to coy down cells but it is increasing the numbers in each cell. How do I do this without it increasing the numbers

With ActiveSheet
        LastR = .Cells(.Rows.Count, "L").End(xlUp).Row
        Range("C2:I2").AutoFill Destination:=Range("C2:I" & LastR)
    End With
ASKER CERTIFIED SOLUTION
Avatar of Rgonzo1971
Rgonzo1971

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Jagwarman
Jagwarman

ASKER

brilliant Rgonzo thanks
always provides a great answer.