asked on VBA date to line code
Folks,
I would like to add the date to a range:
I need to correct my code in the last line. How will that look?
I would like to add the date to a range:
Sub Copy_Paste()
Dim Tdate As Date
Worksheets("Forecast").Range("A4:E7").Copy Worksheets("Historical").Range("A2:E5")
Worksheets("Historical").Range("B2:E5").Interior.Color = vbBlue
Worksheets("Historical").Range("B2:E5").Font.Color = vbRed
Worksheets("Historical").Range("F2:F5").Now
I need to correct my code in the last line. How will that look?
VBA
Last Comment
Frank Freese
Worksheets("Historical").R
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Thanks folks. Noah's solution met my objective.