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

=OFFSET(Consolidated!$A$121,0,1,1,COUNTA(Consolida ted!$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.php...o&userid=33237
View this thread: http://www.excelforum.com/showthread...hreadid=530587