Hi all- I don't know VB but need to accomplish hiding different ranges of rows in my spreadsheet based on the value of a field. The field options for cell f9 are 1-4. If '1' is entered in f9, then I have a range of rows below f9 to hide that don't apply. The same is true for 2 and 3. If 4 is entered, then I want all the rows to show. By searching the internet, I pieced together the following code but it doesn't work. Can you help me fix it. Thanks.
Please Login or Register to view this content.
Last edited by majzeln; 11-04-2016 at 01:42 PM.
Moderation Removed. Code Tags added.
Last edited by Winon; 11-04-2016 at 01:46 PM.
Please consider:
Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .
Hello majzeln,
Thank you.
Use the Code like below:
Please Login or Register to view this content.
Enjoy the Forum!
Regards.
Awesome! Worked like a charm! Thank you very much for your help!
Hi majzeln,
Thank you for the feedback. You are welcome, glad I could help.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks