Refer to cell in Named Range

  • Thread starter Thread starter Ruth
  • Start date Start date
R

Ruth

I know I've seen this somewhere but either I'm asking the wrong question or
Excel online help sux.

Given a named range, MyRange, which is 2 Columns wide by 5 Rows high

How to I refer (either in formala and / or in Macro ) to any particular cell
in that range...eg suppose I want to fetch the value from the 3rd cell down
in Column 2 of MyRange?

Must be bleedin obvious, but ..well please help

thanks
 
Ruth said:
I know I've seen this somewhere but either I'm asking the wrong question or
Excel online help sux.

Given a named range, MyRange, which is 2 Columns wide by 5 Rows high

How to I refer (either in formala and / or in Macro ) to any particular cell
in that range...eg suppose I want to fetch the value from the 3rd cell down
in Column 2 of MyRange?

Must be bleedin obvious, but ..well please help

thanks
Click to expand...
In a Macro

Range("MyRange")(3,2)

Alan Beban
 
Back
Top