Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Populate an array with sheet names?
I would like to get the tab names in a worksheet into an array. How do I
program this? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Populate an array with sheet names?
One way:
Option Explicit Sub testme01() Dim myArr() As String Dim iCtr As Long With ActiveWorkbook ReDim myArr(1 To .Worksheets.Count) For iCtr = 1 To .Worksheets.Count myArr(iCtr) = .Worksheets(iCtr).Name Next iCtr End With End Sub Steve wrote: I would like to get the tab names in a worksheet into an array. How do I program this? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Populate Excel Userform with Sheet names | Excel Programming | |||
populate combobox with sheet names | Excel Programming | |||
populate combobox with sheet names | Excel Programming | |||
Populate cell values with sheet names | Excel Programming | |||
Need to randomly populate a 10x10 array of cells with 100 names - 5 people listed 20 times each... | Excel Programming |