<div>
Hi troy,<br />
<br />
Instead of sticking a formula in there, just stick in a value:<br />
<br />
Cells(r, c) = Date<br />
Cells(r + 1, c) = Date + 1<br />
Cells(r + 2, c) = Date + 2<br />
etc.<br />
<br />
Regards,<br />
<br />
Patrick
</div>


<div>
I don't think that is what I want....I need the first cell in the range &quot;B1&quot;...when created to equal Today()....but then I want the date to stay regardless of the actual date. &nbsp;Know what I mean?<br />
<br />
Troy
</div>


<div>
I gotcha....sweet thanks man!<br />
<br />
Troy
</div>


<div>
<div class="content wysiwyg-content">
I have script that creates a worksheet and a range of dates based the Today() function. &nbsp;But I don't what the start date to update everyday. &nbsp;So how do I start the range using the date the worksheet was created without it updating each day?<br />
<br />
Troy<br />
<br />

</div>
</div>


I have script that creates a worksheet and a range of dates based the Today() function.  But I don't what the start date to update everyday.  So how do I start the range using the date the worksheet was created without it updating each day?

Troy



Hi troy,

Instead of sticking a formula in there, just stick in a value:

Cells(r, c) = Date
Cells(r + 1, c) = Date + 1
Cells(r + 2, c) = Date + 2
etc.

Regards,

Patrick

I don&#39;t think that is what I want....I need the first cell in the range &quot;B1&quot;...when created to equal Today()....but then I want the date to stay regardless of the actual date.  Know what I mean?

Troy

Using Today without Updating after first use

I have script that creates a worksheet and a range of dates based the Today() function.  But I don&#39;t what the start date to update everyday.  So how do I start the range using the date the worksheet was created without it updating each day?

Troy



Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.