Can I try another way?
The following macro puts the date in the active cell:
ActiveCell.FormulaR1C1 = "1/17/2005"
Range("A2").Select
End Sub
Question: How do I edit this so that the cell to the right of
the active cell is selected, when the macro is run?
Thanks for your patience!
George Gee
*JE McGimpsey* has posted this message:
Take a look at
http://www.mcgimpsey.com/excel/accumulator.html
In article ,
"George Gee" wrote:
Hi All
I would like to put today's date into a cell by entering data into
another cell, the following is what I am using now:
= IF(B3="","",TODAY())
If I open the worksheet tomorrow, then the date will change,
how do I get the date to not change?