Hi,
I am trying to copy a date in cell G2 and starting in cell G3 paste it down the rest of the cells in Column G and stop at the last row where there is data.
I am using the below code but it is not working. Appreciate your help. Thanks
I am trying to copy a date in cell G2 and starting in cell G3 paste it down the rest of the cells in Column G and stop at the last row where there is data.
I am using the below code but it is not working. Appreciate your help. Thanks
Code:
Sub PasteDate()
'
' PasteDate Macro
'
'
Range("G2").Select
Selection.Copy
Range("G3:G" & Lastrow).Select
ActiveSheet.Paste
End Sub
Last edited by a moderator: