Excell, How do I put current time in a cell without updating others?
Excell, How do I put current time in a cell without updating others?
(OP)
I'm trying to create a data logg function.
A macro will insert a new row and time in the cell besides it. I am using the function hour (now()) and second(now())
When I insert the function =second (now()) It aslo updates all the other cell that have this function. (Not good)
Each event must keep the time of the event. How do I do this?
A macro will insert a new row and time in the cell besides it. I am using the function hour (now()) and second(now())
When I insert the function =second (now()) It aslo updates all the other cell that have this function. (Not good)
Each event must keep the time of the event. How do I do this?





RE: Excell, How do I put current time in a cell without updating others?
TTFN
RE: Excell, How do I put current time in a cell without updating others?
a = Now
[a1].Value = Hour(a)
[b1].Value = Minute(a)
[c1].Value = Second(a)
Cheers,
Joerd
Please see FAQ731-376 for tips on how to make the best use of Eng-Tips.
RE: Excell, How do I put current time in a cell without updating others?