Compile error: Expected Array

Hi - I am getting a "Compile error: Expected Array" for the below code:

Please Login or Register  to view this content.

I feel like there is a simple thing I am missing, but can't figure it out. Any help is appreciated. Thanks

This will compile and run.

Please Login or Register  to view this content.

Not sure you need an array though if you just want to put the sheet names in cells.

Thanks. I wanted to put the values into the array. This worked. Thanks

That code doesn't put any values in the array.

I know - I updated it

Please Login or Register  to view this content.