Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Loading Sheet Index number into array
I have an array that I want to load sheet index numbers into. The idea being
to load the VBA name of the sheet into the array with the intent of extracting the excel version of the sheet later. So say in the VBA project windows it says: Sheet3 (inputs) How to I load the text value of the VBA name. For example I want the fist element of the array to say "Sheet(3)". Then what I want to do is is I want to extract the actuual excel sheet name "Input" from the index: Sub ExtractSheetName () Dim Sheetcount As Integer Dim SheetName As String For Sheetcount = 1 To B SheetName = ? Debut.Print SheetName Next End Sub |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Loading Sheet Index number into array
Ok I know how to extract the VBA name:
InputSheetArray(0) = Sheet3.CodeName But how do I extract the Excel Name from this? Thanks EM "ExcelMonkey" wrote: I have an array that I want to load sheet index numbers into. The idea being to load the VBA name of the sheet into the array with the intent of extracting the excel version of the sheet later. So say in the VBA project windows it says: Sheet3 (inputs) How to I load the text value of the VBA name. For example I want the fist element of the array to say "Sheet(3)". Then what I want to do is is I want to extract the actuual excel sheet name "Input" from the index: Sub ExtractSheetName () Dim Sheetcount As Integer Dim SheetName As String For Sheetcount = 1 To B SheetName = ? Debut.Print SheetName Next End Sub |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Loading Sheet Index number into array
?sheet3.Name Sheet3 NickHK "ExcelMonkey" wrote in message ... Ok I know how to extract the VBA name: InputSheetArray(0) = Sheet3.CodeName But how do I extract the Excel Name from this? Thanks EM "ExcelMonkey" wrote: I have an array that I want to load sheet index numbers into. The idea being to load the VBA name of the sheet into the array with the intent of extracting the excel version of the sheet later. So say in the VBA project windows it says: Sheet3 (inputs) How to I load the text value of the VBA name. For example I want the fist element of the array to say "Sheet(3)". Then what I want to do is is I want to extract the actuual excel sheet name "Input" from the index: Sub ExtractSheetName () Dim Sheetcount As Integer Dim SheetName As String For Sheetcount = 1 To B SheetName = ? Debut.Print SheetName Next End Sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Index number for CommandBar right-click on sheet tab? | Excel Programming | |||
V-Lookup, column index number indicator in table array | Excel Worksheet Functions | |||
find the index number for an array element | Excel Programming | |||
Loading array into list box | Excel Programming | |||
Loading Excel Array from VB Array Faster | Excel Programming |