I looked in Walkenbach and did a search here, but couldn't find
anything in either about this error when I run a line of code in the
Immediate window, "Invalid Watch Expression". Does anyone know what it
means?

Is the object fully qualified, i.e. not something like

?.Range("A1").Value

but

?activeworkbook.Range("A1").Value

--

HTH

RP
(remove nothere from the email address if mailing direct)


"davegb" wrote in message
oups.com...
I looked in Walkenbach and did a search here, but couldn't find
anything in either about this error when I run a line of code in the
Immediate window, "Invalid Watch Expression". Does anyone know what it
means?

That was it Bob! What does the "?" do?


Bob Phillips wrote:
Is the object fully qualified, i.e. not something like

?.Range("A1").Value

but

?activeworkbook.Range("A1").Value

--

HTH

RP
(remove nothere from the email address if mailing direct)


"davegb" wrote in message
oups.com...
I looked in Walkenbach and did a search here, but couldn't find
anything in either about this error when I run a line of code in the
Immediate window, "Invalid Watch Expression". Does anyone know what it
means?

That is effectively a print statement in the immediate window. Very useful
when debugging to stop execution at some point and check the value of a
variable. Similar to watch, but not updated as the value changes, but you
can also get the values of items that are not in the code but may give you
cause for concern.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"davegb" wrote in message
oups.com...
That was it Bob! What does the "?" do?


Bob Phillips wrote:
Is the object fully qualified, i.e. not something like

?.Range("A1").Value

but

?activeworkbook.Range("A1").Value

--

HTH

RP
(remove nothere from the email address if mailing direct)


"davegb" wrote in message
oups.com...
I looked in Walkenbach and did a search here, but couldn't find
anything in either about this error when I run a line of code in the
Immediate window, "Invalid Watch Expression". Does anyone know what it
means?

Thanks for the explanation, Bob.

Bob Phillips wrote:
That is effectively a print statement in the immediate window. Very useful
when debugging to stop execution at some point and check the value of a
variable. Similar to watch, but not updated as the value changes, but you
can also get the values of items that are not in the code but may give you
cause for concern.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"davegb" wrote in message
oups.com...
That was it Bob! What does the "?" do?


Bob Phillips wrote:
Is the object fully qualified, i.e. not something like

?.Range("A1").Value

but

?activeworkbook.Range("A1").Value

--

HTH

RP
(remove nothere from the email address if mailing direct)


"davegb" wrote in message
oups.com...
I looked in Walkenbach and did a search here, but couldn't find
anything in either about this error when I run a line of code in the
Immediate window, "Invalid Watch Expression". Does anyone know what it
means?