Solution (was Re: Named ranges- how do I "combine" several into a larger named range?)
From: Keith R (nospam_at_nospam.com)
Date: 03/02/04
- Next message: Lee: "Duplicate Names by factor of 4"
- Previous message: AlfD: "Re: The Okopochini Bug"
- In reply to: Keith R: "Named ranges- how do I "combine" several into a larger named range?"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 2 Mar 2004 12:56:29 -0500
Thank you all for your various replies. Having a break in my range(s) was
necessary, so I wasn't able to use the offset function, but Bob's post got
me thinking about how I was doing the union. I think the issue was that I
was including the workbook name in the union, where all I needed was:
[NamedRange1Total] = NamedRange1a,NamedRange1b,NamedRange1c
I also added a new named range [Z] = B1 (a blank cell)
I then took and referenced some cells to find my final range;
[NamedRange1Total] =
if(D1=1,NamedRange1a,Z),if(E1=1,NamedRange1b,Z),if(F1=1,NamedRange1c,Z)
replicated this logic for my X axis labels, and everything works great!
Thanks again for the replies,
Keith
"Keith R" <nospam@nospam.com> wrote in message
news:u6qrYU8$DHA.2316@TK2MSFTNGP10.phx.gbl...
> I started with a large range (1x300 cells) that represented 3 sections of
> data that is graphed- but I've since found out that my (internal) customer
> sometimes needs to suppress one or two of the sections, so the graph
doesn't
> show large empty sections when there is no data.
>
> I'm having trouble with the named range(s);
> Instead of
> NamedRange1 = MySheet!A1:A30
>
> I now have
> NamedRange1a = MySheet!A1:A100
> NamedRange1b = MySheet!A101:A200
> NamedRange1c = MySheet!A201:A300
>
> Now I need a statement that puts all three of these together into one
range
> to feed to the graph, like: (watch for wrap)
>
> NamedRange1Total =
>
MyWorkbook.xls!NamedRange1a,MyWorkbook.xls!NamedRange1b,MyWorkbook.xls!Named
> Range1c
>
> but that doesn't seem to be working- Help!
>
> (after I get the ranges "merged", I can put in if/then logic to control
> whether or not each range is added....)
>
> Many, many thanks in advance!
> Keith
>
>
- Next message: Lee: "Duplicate Names by factor of 4"
- Previous message: AlfD: "Re: The Okopochini Bug"
- In reply to: Keith R: "Named ranges- how do I "combine" several into a larger named range?"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
