Naming new worksheets

P

paz24

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

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

Thanks guy
 
Top