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

VBA: selecting sheets and copy them to a workbook 5
Vlookup and return sheet name also 2
Where best to place an instruction in a VBA script 4
Macro for Multiple Worksheets 6
Copy Array to Array, how to and should I? 13
Search an array of sheets for an array of numbers & return count of numbers 11
Code to 'unbundle' and array 1
Cell values to an array, then array transpose to another workbook 8

Top