ExcelBanter - Cell Reference within NamedRange

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

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

- - Cell Reference within NamedRange (https://www.excelbanter.com/excel-programming/288716-cell-reference-within-namedrange.html)

ExcelMonkey[_12_]

Cell Reference within NamedRange

Is it possible to reference a particular cell within a named range.
That is if I have a range named "SpeciaRange" and it is A1:A10. Can
reference A1.

Range("SpeciaRange").Something????????

--
Message posted from http://www.ExcelForum.com

Ron de Bruin

Cell Reference within NamedRange

Hi ExcelMonkey

Range("SpeciaRange").Cells(1).Select

--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2000-2003)
www.rondebruin.nl

"ExcelMonkey " wrote in message ...
Is it possible to reference a particular cell within a named range.
That is if I have a range named "SpeciaRange" and it is A1:A10. Can I
reference A1.

Range("SpeciaRange").Something?????????

---
Message posted from http://www.ExcelForum.com/

All times are GMT +1. The time now is 02:51 AM.