saneen

I have a formula set for a group of cells which captures the current system date and time at various intervals of time. I have set the Now() function to achieve this. But the problem i am facing is that every time the time is changed all the cells are updated. I would want the formula to run only once. i.e once executed it should not run again. Is this possible anyway. Thanks in Advance.
EDIT: Note i have some macros which run when i open the workbook.

gpraceman

You can create a module level boolean variable to help ensure that it only runs once. If the value is False, then run the formula and set the variable to True; otherwise skip the formula.

saneen

I wonder if i can get away by not creating a macro. I want to do a formula only. Is it possible.

Colin Legg

The Now() function is volatile. It updates pretty much whenever you do something with the worksheet. To stop it updating you would have to copy and pastespecial values which would effectively remove the formula and leave the result. You could use VBA to do this for you.

gpraceman

Duh, you were talking about a forumula. I was thinking that you were running a chunk of code. Yeah, what Colin L said.