Why not just have the range to its maximum value in the first place, is
this not unduly complicating things?

sum(a1:a10) returns the same as sum(a1:a1000) if a11:a1000 are blank

Regards

Dav


--
Dav
------------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=561405