Please help with error, hiding rows

[klunker]

Hi all,
I have the following code to hide rows. Why am I getting an error when I try to declare what rows to select? Syntax? Thanks for the help.

Please Login or Register  to view this content.

[ragulduy]

What is the error - is it highlighting the line in red? It works ok for me if I put spaces between the MaxArray, &, and ":58" parts, i.e.

Please Login or Register  to view this content.

IF that isn't it - what is in D49?

[klunker]

Hi Rag,
Highlights in yellow and gives "select method of Range class failed". Thoughts?

[ragulduy]

Are the rows visible that you are trying to select? Perhaps try getting rid of the select part, for example:

Please Login or Register  to view this content.

[klunker]

Thanks rag, that did it. I still don't understand why the .select wasn't working but oh, well. Thanks again.

[ragulduy]

Either the rows were hidden or another sheet was active, I'd expect.