Hi,

I made some changes to my original module it now reads


Sub copyrow()

Dim EndRow
EndRow = Range("B65536").End(xlUp).Row

Range("f" & EndRow + 1, "k" & EndRow + 1).Formula = Range("f" & EndRow, "k" & EndRow).Formula

End Sub

Basically, I changed .Value to .Formula. Problem now is

1. I'm getting the exact same formula...for example... cell f2=a2+b2, and cell f3 should be =a3+b3, but i'm getting f3=a2+b2.

2. It's not copying the format. Since I'm working with dates and times, I need the formats to be correct.

Soma