Hi all,
I have been working on this code, and I want it to check the cell above for a certain range of cells. If the cell above is empty then hide the entire row. If the cell above is not empty then show the entire row. Since this is being applied to several ranges within the same worksheet, I was wondering how to condense the coding. Any help would be great!
This sample is to individually hide rows B29:B47 based on values in the cell above:
Please Login or Register to view this content.
Last edited by JBeaucaire; 07-31-2013 at 12:48 PM. Reason: Added CODE tags, as per Forum Rules. Take a moment to read the Forum Rules in the menu bar above. Thanks.
Maybe:
Please Login or Register to view this content.
John, thanks for your reply. Your formula seems to hide the row of the cell where the data is entered and not the row below. Any suggestions?
OK then I might be a little confused.
Please Login or Register to view this content.
That works great, I tried reversing it to unhide the same row if the cell above contains any value/text, but that didn't seem to work. Any ideas?
Maybe:
Please Login or Register to view this content.
It still does not seem to work. See attached sample workbook.
Test file.xlsm
ScreenShot1.jpgScreenShot2.jpg
Maybe:
Please Login or Register to view this content.
Wthout talking in code, can you explain briefly HOW you want this to operate? In realtime? Or just when you manually run a macro?
For instance....
"In realtime, I'd like all the rows with no value in B29:B47 to be hidden"
"In realtime, I'd like all the rows with no value in B29:B47 to hide the row below, even if the row below has a value"
"Only when I run a macro by hand, I'd like all the rows with no value in B29:B47 to he hidden"
...etc.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
John - thank you for your quick reply. For some reason it's still not quite working.
JBeaucaire - In real time I want row B29:B47 to be hidden. Once a value (number or text) is entered in B28 I want to show row B29. Subsequently once a value has been entered in B29 I want to show row B30, and so forth. This should all operate automatically (e.g., Private Sub Worksheet_Change(ByVal Target As Range)) without manually running a macro. The goal is to hide extra rows to make the worksheet more manageable and then unhide them once needed. Any suggestions?
Please Login or Register to view this content.
This works perfectly, thanks for your assistance!
I've marked this thread as SOLVED for you.
Next time, select Thread Tools from the links above to mark a 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