Dynamic Named Range

I have the follwing formula to automatically update a graph (the date i
across columns)

=OFFSET(Consolidated!$A$121,0,1,1,COUNTA(Consolidated!$B$121:$IV$121)).


The problem is that some of the cells contains, blanks and I can't see
to make it include all of the information.

What can I do to make this pull pulls in all columns even if there ar
blanks?


Thanks in advance.

Michelll

--
bountifulgrac
-----------------------------------------------------------------------
bountifulgrace's Profile: http://www.excelforum.com/member.ph...nfo&userid=3323
View this thread: http://www.excelforum.com/showthread.php?threadid=53058

try this idea if text. substitute 999999999 if numbers. Excel will put in
the sheet if you do if while on the consolidated sheet

=OFFSET($A$121,0,0,1,MATCH("zzzzzzz",$121:$121))

--
Don Guillett
SalesAid Software
dguillett1@austin.rr.com
"bountifulgrace"
<bountifulgrace.25uqxz_1144342806.0592@excelforum-nospam.com> wrote in
message news:bountifulgrace.25uqxz_1144342806.0592@excelforum-nospam.com...
>
> I have the follwing formula to automatically update a graph (the date is
> across columns)
>
> =OFFSET(Consolidated!$A$121,0,1,1,COUNTA(Consolidated!$B$121:$IV$121)).
>
>
> The problem is that some of the cells contains, blanks and I can't seem
> to make it include all of the information.
>
> What can I do to make this pull pulls in all columns even if there are
> blanks?
>
>
> Thanks in advance.
>
> Michellle
>
>
> --
> bountifulgrace
> ------------------------------------------------------------------------
> bountifulgrace's Profile:
> http://www.excelforum.com/member.ph...fo&userid=33237
> View this thread: http://www.excelforum.com/showthrea...threadid=530587
>