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
JagwarmanAsked:
Who is Participating?
 
Rgonzo1971Connect With a Mentor Commented:
Hi,

pls try

With ActiveSheet
        LastR = .Cells(.Rows.Count, "L").End(xlUp).Row
        Range("C2:I2").AutoFill Destination:=Range("C2:I" & LastR), Type:=xlFillCopy
    End With

Regards
0
 
JagwarmanAuthor Commented:
brilliant Rgonzo thanks
0
 
JagwarmanAuthor Commented:
always provides a great answer.
0
All Courses

From novice to tech pro — start learning today.