If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
|
#1
|
|||
|
|||
Hide Row if .....
Excel 2003:
This one is likely so simple, I didn't dare post to programming. I need this now, to keep boss happy - Else I would spend more study time on it. Sorry. Note: If possible, macro to work back to 1997 Excel version. Sorting to group condition not an option. Question: If cell B? = *, then check next row. If cell B? is blank, then hide row, then check next row. If cell B? = **, then hide that and stop macro. ( the ** indicates 1st row below any required data) Please advise if there is a better way to end the macro. The nice part about using something like **, is that it gives me a clear visual of situation. Thanks in advance. -- John F. Scholten |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Hide Rows and Cols to infinity | Rich | New Users | 5 | September 14th, 2004 12:05 AM |
Can't hide a control on a subform | Fred Parkinson | Using Forms | 3 | September 9th, 2004 05:15 PM |
Hide colum | rodw | General Discussion | 2 | July 29th, 2004 11:51 AM |