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.

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 -

Anthony,

? now()

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

HTH,
Bernie
MS Excel MVP

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