Hide a range of rows based on cell values.

[klunker]

Hi All,
I've been trying to put together some code to hide a range of rows on one page based on cell values on a different page. So basically Sheet1 cell A1 value is 10, A2 value is 20. When macro is run via button rows on Sheet2 from 10-20 would be hidden. The issue is the values in the cells on Sheet1 will vary. I thought something like the following would work but it doesn't. Any suggestions would be a great help. Thanks.

Please Login or Register  to view this content.

[Solus Rankin]

Perhaps

Please Login or Register  to view this content.

This should hide it. If the values are changed do the previously hidden rows need to be unhidden before the new values are hidden?

[patel45]

Please Login or Register  to view this content.

[Solus Rankin]

Here is another option if you would like the previous hidden rows unhidden first

Please Login or Register  to view this content.

[klunker]

Thanks Solus for the quick and very helpful reply! I had a feeling it had to do with my formatting of the "True" line.

[klunker]

Thanks patel45. Both yours and Solus's fixes work great!

[Solus Rankin]

Glad to help.

If you are satisfied with the solution please mark the thead as [SOLVED] using the thread tools at the top.