View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Immediate window error

in the immediate window, you use

? now

or
debug.print now

(? is a shortcut for debug.print)

to see the current date and time.

--
Regards,
Tom Ogilvy


"Anthony" wrote in message
...
I'm getting an error everytime I try to use the immediate
window function (compile error: Expected line number or
label at the end of the statement)

I'm using such statements at =now() which usually works.
If you know what this error please let me know -