| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How preserve the value of NOW() or TODAY()?
I like to write code to preserve the value of NOW() or TODAY().
When user opens the workbook the first time current system date + 30 day should be recorded and it should not change with subsequent openings of the workbook. I can do that manually inserting TODAY() into A1 then copy/paste special/values only to B1. Then make C1 = B1 + 30 How to do it in an efficinet macro. I know that I can use Range("A1").Copy Range("B1") but this copies the formula not just the value. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I Preserve Borders? | Excel Discussion (Misc queries) | |||
| IF TODAY equals date in cell A10, or if TODAY is beyond that date | Excel Worksheet Functions | |||
| Preserve format | Excel Discussion (Misc queries) | |||
| Preserve settings | Excel Discussion (Misc queries) | |||
|
=IF(OR(TODAY() |
Excel Discussion (Misc queries) | |||
Threaded Mode
