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.
PerhapsThis should hide it. If the values are changed do the previously hidden rows need to be unhidden before the new values are hidden?Please Login or Register to view this content.
Thanks,
Solus
Please remember the following:
1. Use [code] code tags [/code]. It keeps posts clean, easy-to-read, and maintains VBA formatting.Highlight the code in your post and press the # button in the toolbar.2. Show appreciation to those who have helped you by clickingbelow their posts.
3. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.
"Slow is smooth, smooth is fast."
Please Login or Register to view this content.
If solved remember to mark Thread as solved
Here is another option if you would like the previous hidden rows unhidden firstPlease Login or Register to view this content.
Thanks Solus for the quick and very helpful reply! I had a feeling it had to do with my formatting of the "True" line.
Thanks patel45. Both yours and Solus's fixes work great!
Glad to help.
If you are satisfied with the solution please mark the thead as [SOLVED] using the thread tools at the top.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks