Macro for hiding sheets

[mdoverl]

I have been working on a macro to close a number of sheets, the file contains over 100 sheets lol (maybe part of the problem). But when running the macro I run across an error [Run-time error '9': Subscript out of range]. I am far from an expert in excel and am mostly self taught, I copied and pasted most of the macro and I will paste the full macro below in green: Error message and line will be highlighted in red. Remember, I'm not an expert, so if someone could point me in the right direction that would be fantastic.

Please Login or Register  to view this content.

[am_hawk]

I would make sure "StoneAgeWeapons" exists and that it is spelled correctly no space on the end. For reference, Run-time error 9: Subscript out of range means you are referencing a non-existent array element.

[mdoverl]

Alright thanks, I was checking the name to make sure it was right, but I never checked for spaces at the end of the sheet name, will check right now, plus it's nice to know exactley what that means

[JOHN H. DAVIS]

Are you intentionally using that light green color to make your code harder to read and understand?

[mdoverl]

LOL you were completely right, there was a space at the end, I can't believe it never thought of looking at that, thank you very much am_hawk

[mdoverl]

Sorry John, I'll make sure to use more friendly colors next time, i see if there is standards for the forum listed

[JOHN H. DAVIS]

Sorry John, I'll make sure to use more friendly colors next time, i see if there is standards for the forum listed

Some us guys are old and can hardly see it in black.