| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Problem adding multiple worksheets
Great thanks
"Kevin B" wrote: Your last worksheet name, AMCON DISTRIBUTING - SPRINGFIELD, is one character beyond the tab name maximumn of 31 characters. Try abbreviating it to AMCON DISTRIB - SPRINGFIELD or something along those lines. -- Kevin Backmann "pokdbz" wrote: 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 |
| Reply |
| 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 | |||
Hybrid Mode
