Sheets.Add

G

Guest

I am using Excel 2003 w/MVB 6.3
I have a macro in VBE that shows a comment of 'create a blank sheet, then
the next line shows Sheets.add.
I would like the sheet being added to be formattted as 'TEXT' instead of the
default 'GENERAL'. Can anyone help?

Thank you in advance for your assistance.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sheets.Add Function 4
Using Sheets.Add after and want to keep a sheet as the first sheet 2
Excel 2010 Windows.Activate name issue 4
Word to Excel: Export comments with text and line number 0
Save value on form 4
Creating 64 new wsheets and naming them in vba 6
File Open Multiselect 1
Button for every sheet one new email 0

Top