| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheet name
Excel Experts, I have a workbook which has a sheet named "BskTrades". I want my code to add a new sheet after BskTrades and name it "BskTotals". My code adds a new sheets after BskTrades but fails on the second line which I want to name the new sheet "BskTotals". What do I have wrong? Sub AddSheet() Sheets.Add After:=Worksheets("BskTrades") Worksheets(Worksheets("BskTrades").Count + 1).Name = "BskTotals" End Sub Thanks in advance, Alan -- achidsey |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| automatically appending newly added data on worksheet to a master list worksheet | Links and Linking in Excel | |||
| plot graph from multiple worksheet as embedded chart object on every worksheet | Excel Discussion (Misc queries) | |||
| Upload multiple text files into 1 excel worksheet + put the filename as the first column in the worksheet | Excel Worksheet Functions | |||
| copy range on every worksheet (diff names) to a master worksheet (to be created) | Excel Programming | |||
| Attaching a JET database to an Excel Worksheet OR storing large binary data in a worksheet | Excel Programming | |||
Threaded Mode
