VBA to create an Array of all Sheets in workbook

  • Thread starter Thread starter Guy Hoffman
  • Start date Start date
G

Guy Hoffman

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
 
See one more reply at your other post.


Guy Hoffman < said:
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
Click to expand...
 
Back
Top