Use Otto's method. You won't need to disturb the original worksheet in any
way.
--
Gary''s Student


"girth69" wrote:


i think there is a find next blank formula that may be suitable for this
but not sure what exactly it is??


--
girth69
------------------------------------------------------------------------
girth69's Profile: http://www.excelforum.com/member.php...o&userid=23634
View this thread: http://www.excelforum.com/showthread...hreadid=532316