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.