Is there a way in excel (or even visual basic) to assign a pre-defined
name to a new worksheet.

Basically, I have this VBA program which creates new worksheets. Each
worksheet is sequenced (sheet1, sheet2 etc). Is there some way in
excel/VBA to give a new worksheet a particular name instead of just
"sheet1" or "sheet2".

Thanks guys


--
paz24
------------------------------------------------------------------------
paz24's Profile: http://www.excelforum.com/member.php...o&userid=31046
View this thread: http://www.excelforum.com/showthread...hreadid=507180