Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a worksheet that calculates some astronomical positions according to
the current time of day. Of course as time progresses, the numbers change. I found a few websites that provide a copy and paste routine in VB format but I can't seem to get them to update the time every minute without manually doing a refresh. It's only one cell that needs updating every minute and the rest of the calculations should automatically follow from that. I am using Excel 2002. I know some programming languages but VB isn't one of them. Also, if anyone can point me to a small subroutine to do this, I'd be appreciative. Thanks for your reply. -- David Farber L.A., CA |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Value Function not updating | Excel Worksheet Functions | |||
Updating Function | Excel Programming | |||
How can I use the NOW function and keep it from auto updating? | Excel Worksheet Functions | |||
convert time from 60 minute hour to 100 minute hour | Excel Discussion (Misc queries) | |||
convert 100 minute hour to a 60 minute hour | Excel Worksheet Functions |