Compile error: Expected Array

[jkj115]

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

[Norie]

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.

[jkj115]

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

[Norie]

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

[jkj115]

I know - I updated it

Please Login or Register  to view this content.