If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How do I keep the "today()" function from updating
I have a macro that adds a new line to our construction budgets. It puts the
date of the change by using the today function to put that day's date in the first cell of the new row. In Excel 2003, this date would remain static, which is what I wanted. When I upgraded to Excel 2007, the date would change to the current date, which made the information useless. How can I get the date to remain the date it was first inserted in the cell? |
#2
|
|||
|
|||
How do I keep the "today()" function from updating
Hi
Behaviour has not altered between XL2003 and 2007 in this respect. If a cell contains =TODAY(), it is volatile and will be recalculated every time there is a change in the worksheet, so the date will alter day by day. Perhaps your original macro did something like ActiveSheet.Range("A" & nextrow)=Date where nextrow is the next row number on the sheet In this case the Date would be fixed to the value at the time the macro was run It sounds as though the macro now does something like ActiveSheet.Range("A" & nextrow).Formula = "=Today()" -- Regards Roger Govier "Len Chaston" wrote in message ... I have a macro that adds a new line to our construction budgets. It puts the date of the change by using the today function to put that day's date in the first cell of the new row. In Excel 2003, this date would remain static, which is what I wanted. When I upgraded to Excel 2007, the date would change to the current date, which made the information useless. How can I get the date to remain the date it was first inserted in the cell? __________ Information from ESET Smart Security, version of virus signature database 4756 (20100109) __________ The message was checked by ESET Smart Security. http://www.eset.com __________ Information from ESET Smart Security, version of virus signature database 4756 (20100109) __________ The message was checked by ESET Smart Security. http://www.eset.com |
#3
|
|||
|
|||
How do I keep the "today()" function from updating
It would be much easier for someone to give you an answer if you posted the
macro's code for us to see. -- Rick (MVP - Excel) "Len Chaston" wrote in message ... I have a macro that adds a new line to our construction budgets. It puts the date of the change by using the today function to put that day's date in the first cell of the new row. In Excel 2003, this date would remain static, which is what I wanted. When I upgraded to Excel 2007, the date would change to the current date, which made the information useless. How can I get the date to remain the date it was first inserted in the cell? |
Thread Tools | |
Display Modes | |
|
|