VBA to create an Array of all Sheets in workbook

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
 
D

Dave Peterson

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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Vlookup and return sheet name also 2
Code to copy worksheet 5
Cell values to an array, then array transpose to another workbook 8
Array to Multiple Arrays 3
Creating an ARRAY UDF 0
Where best to place an instruction in a VBA script 4
How to make it work for "WHOLE" workbook 4
The easiest way to copy a sheet of formulas! (Excel 2007) 1

Top