| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel worksheets and VB .NET
Hi, I need to conditionally rename a worksheet in an excel 2000 workbook.
I have the following piece of code: application.excel.worksheets("SheetName").Name = "NewSheetName" which works to rename it. However, if SheetName doesn't exist or has been renamed the program throws and exception. How can I check to make sure that a sheet exists in the sheets collection? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Unable to save modified Excel 2003 worksheets using Excel 2007 | Excel Discussion (Misc queries) | |||
| How use info in Excel shared worksheets to create new worksheets | Excel Worksheet Functions | |||
| Weird problem with Excel 2000...Worksheets disappearing in a shared Excel file | Excel Discussion (Misc queries) | |||
| How to send Excel 2000 worksheets to Excel 2003? | Excel Discussion (Misc queries) | |||
| Need code to protect worksheets - amount of worksheets varies | Excel Programming | |||
Threaded Mode
