o.k.

I kind of get it... (I immediately get lost in R1C1 world) but...
I'm not sure,

am I editing the code where is the value to true
or,
editing the code where I check if the value is true?

and, in either case (excuse my dumbness), could you spell out what the exact
code ought to be

-mark

-------------------------------------------------------------------------------------------------


"bobbo" wrote in message
oups.com...
After "RefesToR1C1:= " you need something that refers to a range in
R1C1 format.
Then to set it to true
Activeworkbok.Names("ReformatingCompleted").Refers ToRange.Value =
"True"

mark kubicki wrote:
even though the value for [ReformatingCompleted] seems to have been set
to
"True", I'm not able to test for it correctly;
could someone proof this short code for me? (it's prob an obvious
mistake...
u know how that goes...)

--------------------
ActiveWorkbook.ActiveSheet.Names.Add Name:="ReformatingCompleted",
RefersToR1C1:="=""True"""


If ActiveWorkbook.ActiveSheet.Names("ReformatingCompl eted").Value =
"True"
Then
Exit Sub
End If
--------------------


thanks in advance,
mark