| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Name of Added Worksheet
If I add a worksheet as in the code below, can I force the name of the new
sheet to something because this code was working fine on my PC, but on another user's pc, the added sheet was Sheet4. Instead of changing their template or whatever might be causing this, can I just force the new sheet to some name, or can I otherwise determine the name of the new sheet and then go to it. My next line of code is to rename this sheet1 anyway. Sheets.Add Type:="Worksheet" Sheets("Sheet1").Select |
| 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 | |||
| why is ...xls] being added to the name on my worksheet? | Excel Worksheet Functions | |||
| Detect New Worksheet being added | Excel Programming | |||
| How to select an added worksheet | Excel Programming | |||
| Stop Worksheet being added | New Users to Excel | |||
Threaded Mode
