try this

range("sales").address

--


Gary


"Simon" wrote in message
...
Hi There,

How do you get the cell references of a named range. I need to create a
formula within a macro which will be assigned to a particular cell, however
I'm having trouble doing this. I need the cell references of the particular
named range. The named range is only one cell eg. SALES is A5.

Thanks
Simon