ExcelBanter - Named Range Macro Formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Named Range Macro Formula (https://www.excelbanter.com/excel-programming/379888-re-named-range-macro-formula.html)

Gary Keramidas

Named Range Macro Formula

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

All times are GMT +1. The time now is 01:10 AM.