To use a worksheet named range in VB use ([ and ]) like ([PctOverall]) eg
Sheet1.Range([PctOverall]).Copy
Regards,
Alan.
"Blue Hornet" wrote in message
ups.com...
This seems so silly that I can hardly believe that I need to ask, but
...

How can I use my Named Range "PctOverall" (an overall % complete number
stored in the worksheet) in a macro?

All I want is to display the value in a text box on the screen for a
few seconds. I have the code to write and later delete the text box,
the text to appear inside as "boilerplate" and ... I can't use my
Range("PctOverall").Value

What's the text to replace the "W1" value below? I want this because
the sheet may be modified with inserted or deleted columns, and I don't
want to have to change "W1" as it moves around.

Selection.Characters.Text = "Overall Percent Complete = " & _
Application.Text(Range("W1").Value, "#0.####%")

Thanks,
Chris