| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Name each Worksheet with a name?
I have looked high and dry for this information and cant seem to find what I
am needing to do. I have tried it everywhich way and cant seem to get anything to work, so any help would be GREATLY appreciated! Thank you in advance! I have some VB code that I need to write in C# to allow me to name each tab(sheet) in an excel workbook, everything I try isnt working right. Private Sub SetupWorksheet() Dim count As Integer For count = 1 To ThisWorkbook.Sheets.Count ThisWorkbook.Sheets(count).Name = "Temp " & count Next ThisWorkbook.Sheets(1).Name = "ALL SUMMARY" ThisWorkbook.Sheets(2).Name = "Preferred" ThisWorkbook.Sheets(3).Name = "Standard" |
| 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 | |||
| Unable to Insert Worksheet/Move and copy worksheet Excel 2003 | Excel Worksheet Functions | |||
| 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
