http://www.mvps.org/dmcritchie/excel/sheets.htm

this site has a worksheet change code that adds a sheet when column f
changes


this site has code for adding rows
http://www.mvps.org/dmcritchie/excel/insrtrow.htm

heres a code that checks the selected range, if there is a sheet name
in the selected range..well I will attatch the post and you can see
what it does
http://forums.techguy.org/business-a...l-content.html


--
davesexcel


------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=537521