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