A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Hide Row if .....



 
 
Thread Tools Display Modes
  #1  
Old November 4th, 2004, 03:08 PM
John F
external usenet poster
 
Posts: n/a
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

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


All times are GMT +1. The time now is 02:49 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.