Getafix1066
Board Regular
- Joined
- May 15, 2016
- Messages
- 57
Hi,
This is a follow on question from a previous posting of mine. Hopefully someone here can provide some insight.
I have created three different named ranges as follows.....
=Template!$H$85:$H$1005
=OFFSET(INDIRECT("$H"&Template!$C$23),0,0,Template!$C$29)
=OFFSET(INDIRECT("Template!$H"&Template!$C$23),0,0,Template!$C$29)
These three different ranges all refer to exactly the same set of cells. And as far as I can tell they all work. If I go into 'name manager' and highlight one of the named ranges and then click in the 'refers to' box then the expected set of cells are highlighted. At this stage I get no errors, and it's always the same set of cells that get highlighted - I take this to mean that all the named ranges are valid.
Here's the issue. If I then attempt to create a chart using these ranges then despite the fact they all refer to the same set of values only two of them will work! (the first and last one will work, the middle one won't)
Have I missed something here? To my thinking any object (i.e. a range) should either be valid, on invalid. An object that is valid only in some circumstances but not others is inevitably going to cause confusion. Or am I simply doing something wrong?
This is a follow on question from a previous posting of mine. Hopefully someone here can provide some insight.
I have created three different named ranges as follows.....
=Template!$H$85:$H$1005
=OFFSET(INDIRECT("$H"&Template!$C$23),0,0,Template!$C$29)
=OFFSET(INDIRECT("Template!$H"&Template!$C$23),0,0,Template!$C$29)
These three different ranges all refer to exactly the same set of cells. And as far as I can tell they all work. If I go into 'name manager' and highlight one of the named ranges and then click in the 'refers to' box then the expected set of cells are highlighted. At this stage I get no errors, and it's always the same set of cells that get highlighted - I take this to mean that all the named ranges are valid.
Here's the issue. If I then attempt to create a chart using these ranges then despite the fact they all refer to the same set of values only two of them will work! (the first and last one will work, the middle one won't)
Have I missed something here? To my thinking any object (i.e. a range) should either be valid, on invalid. An object that is valid only in some circumstances but not others is inevitably going to cause confusion. Or am I simply doing something wrong?