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
With ActiveSheet
LastR = .Cells(.Rows.Count, "L").End(xlUp).Row
Range("C2:I2").AutoFill Destination:=Range("C2:I" & LastR)
End With
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
always provides a great answer.
ASKER