And to remove dollar signs you would select the Refers to: box and hit F2 to get
into edit mode.

Select the referenced cells and F4 to cycle through the options untill you get
to relative reference.


Gord Dibben MS Excel MVP

On Mon, 14 Aug 2006 12:42:01 -0700, David Billigmeier
wrote:

Yes, follow these steps:

<Insert<Name<Define...
Find your named range in the list and take out the dollar signs.