VBA autofill date

[caritx]

Hi I have a date in cell:

C2: 03/22/2010

I want to copy and paste to the last row. Normally I would do this but with autofill it changes the value. Please help!

Range("C2").Select
Selection.Copy
Range("C2").AutoFill Destination:=Range("C2:C" & LR)

 

[Datsmart]

If you do not want it to increment the date during AutoFill, hold down the Ctrl key while you drag it.

 

[jeffreybrown]

Change your code to and it won't increment

Range("C2").Copy Destination:=Range("C2:C" & LR)