Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA to create an Array of all Sheets in workbook
Need some code to create an array called MySheets that includes al
sheet names in the workbook. I'm then going to use the array in the following formula: Number SUMPRODUCT(COUNTIF(INDIRECT("'"&MySheets&"'!"&CELL ("address",A1)),"0")) Likely would use a For Next construct to cycle through the sheets bu I'm stuck. Thank -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA to create an Array of all Sheets in workbook
Guy,
Chip Pearson covers thsi quite well at http://www.cpearson.com/excel/excelM.htm#SheetNames --- Message posted from http://www.ExcelForum.com/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA to create an Array of all Sheets in workbook
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA to create an Array of all Sheets in workbook
See one more reply at your other post.
"Guy Hoffman <" wrote: Need some code to create an array called MySheets that includes all sheet names in the workbook. I'm then going to use the array in the following formula: Number = SUMPRODUCT(COUNTIF(INDIRECT("'"&MySheets&"'!"&CELL ("address",A1)),"0")) Likely would use a For Next construct to cycle through the sheets but I'm stuck. Thanks --- Message posted from http://www.ExcelForum.com/ -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I create a quick directory of sheets in workbook | Excel Discussion (Misc queries) | |||
Macro to create new workbook and sheets | Excel Discussion (Misc queries) | |||
CREATE MULTIPLE WORK SHEETS IN A WORKBOOK | Excel Worksheet Functions | |||
Multiple Sheets (Need to create 500 individual sheets in one workbook, pulling DATA | Excel Worksheet Functions | |||
How to create workbook with multiple sheets | Excel Discussion (Misc queries) |