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

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/

VBA to create an Array of all Sheets in workbook
 

Thank you. I feel very silly

--
Message posted from http://www.ExcelForum.com

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