NOW() Function

mrchuffster

New Member
Joined
Dec 23, 2005
Messages
1
Hey there,

A Question about the NOW() Function, How would you get it to keep updating time in Real Time. Is there another function/Switch or would I have to write a Macro?

Thanks in Advance
 

Some videos you may like

Excel Facts

Can Excel fill bagel flavors?
You can teach Excel a new custom list. Type the list in cells, File, Options, Advanced, Edit Custom Lists, Import, OK

XLGibbs

Well-known Member
Joined
Feb 25, 2005
Messages
2,446
Not sure what you mean, but every time the sheet recalculates, it would update...do you want it to constantly update without stopping?

That would require a macro of some sort...

Like an endless loop that recalculated the sheet, but the rest of the workbook would be practically dead while the loop was running...there may be another way that one of the MVPs knows of..
 

Watch MrExcel Video

Forum statistics

Threads
1,119,144
Messages
5,576,326
Members
412,716
Latest member
thviid
Top