| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Problem adding multiple worksheets
I'm using this to add mulitple work sheets
Set ws = Worksheets.Add ws.Name = sheetName ' error line I am pulling sheetName from another worksheet and am getting an error when it goes to make the 3rd worksheet. The error message: Runtime error '1004' Application defined or object defined error I'm not sure what the problem is since it makes two worksheets fine and fails on the third. These are the worksheet names it creates in this order. AJ SILBERMAN & CO AMCON DISTRIBUTING CO - OMAHA AMCON DISTRIBUTING - SPRINGFIELD |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding multiple worksheets using a table | Excel Worksheet Functions | |||
| Adding a Row to Multiple Worksheets at Once | Excel Worksheet Functions | |||
| Adding multiple worksheets | Excel Worksheet Functions | |||
| Adding multiple worksheets | Excel Worksheet Functions | |||
| adding certain cells in multiple worksheets in multiple workbooks | Excel Worksheet Functions | |||
Threaded Mode
