It might be helpful to look at
http://www.mvps.org/dmcritchie/excel/insrtrow.htm
http://www.mvps.org/dmcritchie/excel/offset.htm
to see why I would use OFFSET in the formulas so you can
insert and delete rows.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Senior" wrote in message
...

THANKYOU VERY MUCH MATE!!

it's worked, much much appreciated :)


--
Senior
------------------------------------------------------------------------
Senior's Profile: http://www.excelforum.com/member.php...o&userid=32672
View this thread: http://www.excelforum.com/showthread...hreadid=524794