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