Error with an Array in a macro

Hi,

I am a starter in VBA. Below is apart of code in which I am getting run time error 13 at the bolded and the under lined line. Can I have some suggestions how to rectify this.

Please Login or Register  to view this content.

Any Help on where I am going wrong.

Posted here also but invain:http://www.mrexcel.com/forum/showthread.php?t=388162

To answer your question...

You must ReDim the Array before you can populate, eg pre j loop:

Please Login or Register  to view this content.

You will need to revise your n loop also to make use of the fact that the Array holds sheet names, ie:

Please Login or Register  to view this content.

IMO it's also a good habit to get into releasing Objects prior to End of Routine, eg:

Please Login or Register  to view this content.

An altogether alternative approach if this is all you're looking to do (ie colour range) would be:

Please Login or Register  to view this content.