LinkBack URL
About LinkBacks
Can I write a VBE so that (for example)
If Rows 10:20 are hidden,
then hide Row 9
Does anyone know how I can do this?
Can I write a VBE so that (for example)
If Rows 10:20 are hidden,
then hide Row 9
Does anyone know how I can do this?
I am guessing there is more to the problem?
Hiding a single sheets is as easy as right clicking the tab and clicking hide, what is the value of automating this?
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."
Solus is right. Giving you the answer to your specific question is easy. But I highly doubt it will solve your true problem.
Please Login or Register to view this content.
RG WORKING_3.xlsm
I have a range of cells that pull from a separate sheet. When the row returns a blank, I have code to hide that row.
Between sections of rows there is a gray "divider" row. If everything in the section returns a blank all of the rows in the section will be hidden. If all the whole section is hidden, then I want the divider row to hide as well. I'm attaching my workbook for reference. See the "Tracking" Sheet.
Thank you!
Replace your current HideOnEmpty macro with this one. Much faster. If it works for you feel free to click the star in the bottom left corner.
*Note: The only way I could think of working this was based upon the color of the "grey" line. If that color changes or you choose a different but similar color in the future, it won't work.
Please Login or Register to view this content.
Last edited by stnkynts; 07-22-2013 at 04:16 PM.
This is awesome! Thank you so much!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks