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