I'm looking to build a variable data range to help in some charting.
I've tried a few forumla/text combos and have had no luck thus far. I'm
wondering what is exceptable to use in the data range feild.


Is the string I've tried. Basically I'm looking to create an open ended
data range. Any help??

='Chart Info'!$H$40:$I$"&COUNT(I:I)+39&",'Chart
Info'!$M$40:$N$"&COUNT(I:I)+39



Thanks!
Ryan


--
low98
------------------------------------------------------------------------
low98's Profile: http://www.excelforum.com/member.php...o&userid=30316
View this thread: http://www.excelforum.com/showthread...hreadid=499794