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.