Hi Guys.
Any help with this appreciated.
I'm running a clock in an excel sheet that refreshes every second which is fine. I then have a macro button that when clicks I want to insert a static time. Now() isn't any good here. I thought I had it sorted by using Cmd ; to insert the time but when I recorded the macro and looked at the code it's just putting in the static value from the time I recorded the macro and not the time, and each time the button is activated. Is there a way that cmd ; can be coded into a macro?
Thanks in advance (toughie!)
G
Bookmarks