NOW() Function

[mrchuffster]

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

 

[XLGibbs]

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..