<div>
Worksheets(&quot;Historical&quot;).R<wbr />ange(&quot;F2:F<wbr />5&quot;) = Now
</div>


Worksheets("Historical").Range("F2:F5") = Now

Frank Freese

Developer & Coffee Roaster

Scott Fell

<div>
Thanks folks. Noah's solution met my objective.
</div>


Thanks folks. Noah's solution met my objective.

<div>
<div class="content wysiwyg-content">
Folks,<br />
I would like to add the date to a range:<br />

<pre><code id="code-10-29167849-1">Sub Copy_Paste()
Dim Tdate As Date

Worksheets(&quot;Forecast&quot;).Range(&quot;A4:E7&quot;).Copy Worksheets(&quot;Historical&quot;).Range(&quot;A2:E5&quot;)
Worksheets(&quot;Historical&quot;).Range(&quot;B2:E5&quot;).Interior.Color = vbBlue
Worksheets(&quot;Historical&quot;).Range(&quot;B2:E5&quot;).Font.Color = vbRed
Worksheets(&quot;Historical&quot;).Range(&quot;F2:F5&quot;).Now</code></pre>
<br />
I need to correct my code in the last line. How will that look?
</div>
</div>


Folks,
I would like to add the date to a range:
(CODE)

I need to correct my code in the last line. How will that look?

VBA date to line code

Visual Basic for Applications (VBA) enables building user-defined functions (UDFs), automating processes and accessing Windows API and other low-level functionality through dynamic-link libraries (DLLs). VBA is closely related to Visual Basic and uses the Visual Basic Runtime Library, but it can normally only run code within a host application rather than as a standalone program. It can, however, be used to control one application from another via OLE Automation. VBA is built into most Microsoft Office applications.