Sheet Auto-Update

JHughes

New Member
Joined
Oct 19, 2006
Messages
13
I'm using the NOW() function on a spreadsheet Im creating and want to know how to get it to count up realtime without me having to hit the F9 key. Is this just a setting in Excel or does anyone have a program that will literlly press the F9 every second?
 

Some videos you may like

Excel Facts

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.

Oaktree

MrExcel MVP
Joined
Jun 20, 2002
Messages
7,984
You will need to use a macro.

Have a look at the OnTime method in VBA help...
 

Watch MrExcel Video

Forum statistics

Threads
1,114,059
Messages
5,545,759
Members
410,704
Latest member
Cobber2008
Top