ExcelBanter - View Single Post - Creating a new worksheet

Thread: Creating a new worksheet

View Single Post

#4

Report Post

Posted to microsoft.public.excel.programming

JasonK[_3_] JasonK[_3_] is offline

JasonK[_3_] is offline

external usenet poster

Posts: 38

Default

Creating a new worksheet

Thanks OssieMac --

On Sun, 3 Jan 2010 13:29:01 -0800, OssieMac
wrote:

Just for interest you can also add the sheet and name it in one line.

ActiveWorkbook.Worksheets.Add.Name = shtName

Reply With Quote

Reply With Quote