ExcelBanter - Sheets.Add

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Sheets.Add (https://www.excelbanter.com/excel-programming/391895-sheets-add.html)

MsKitty_1949

Sheets.Add

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.

Mark

Sheets.Add

Sheets.Add
ActiveSheet.Cells.NumberFormat = "@"

"MsKitty_1949" wrote:

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.

All times are GMT +1. The time now is 10:30 AM.