troyhalsey
asked on
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'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
Troy
ASKER
I don't think that is what I want....I need the first cell in the range "B1"...when created to equal Today()....but then I want the date to stay regardless of the actual date. Know what I mean?
Troy
Troy
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I gotcha....sweet thanks man!
Troy
Troy
You're most welcome :)
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