Try:

Worksheets("Sheet1").Range("SALES").Address
--
Hope this helps
Martin Fishlock, Bangkok, Thailand
Please do not forget to rate this reply.


"Simon" wrote:

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