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

Guy,

Chip Pearson covers thsi quite well at
http://www.cpearson.com/excel/excelM.htm#SheetNames


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

Thank you. I feel very silly

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

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