Immediate window error

[Anthony]

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 - thanks.

 

[Tom Ogilvy]

in the immediate window, you use

? now

or
debug.print now

(? is a shortcut for debug.print)

to see the current date and time.

 

[Bernie Deitrick]

Anthony,

? now()

is the proper syntax for the immediate window....

HTH,
Bernie
MS Excel MVP