Hi Everyone,
In cell A2 I have a date. I want to copy that date from A3 down to the last row that would have data in Column F
I can get it with the code below BUT the last row is always different so it would need to be changed daily.
For example today the last row was 397 but tomorrow it may be 390 or 420, etc.
Thanks in advance!!
In cell A2 I have a date. I want to copy that date from A3 down to the last row that would have data in Column F
I can get it with the code below BUT the last row is always different so it would need to be changed daily.
For example today the last row was 397 but tomorrow it may be 390 or 420, etc.
Thanks in advance!!
Code:
Sub CopyDate()'
' CopyDate Macro
'
'
Selection.Copy
Range("A3:A397").Select
ActiveSheet.Paste
End Sub