Home
Forums
New posts
Search forums
Articles
Latest reviews
Search resources
Members
Current visitors
Newsgroups
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Search forums
Menu
Log in
Register
Install the app
Install
Home
Forums
Newsgroups
Microsoft Excel
Microsoft Excel Programming
simple code hide/show rows with cell = empty, set value or any val
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Reply to thread
Message
[QUOTE="Guest, post: 8652977"] This was very quick and dirty because I have to pack it in. I likely have the logic wrong but I think the approach is correct. I'll leave it to you to correct the condition statements assuming I have them wrong: Dim rng3 As Range, rng4 As Range Dim wf As WorksheetFunction Dim cond1 As Boolean, cond2 As Boolean Set wf = Application.WorksheetFunction Set rng3 = Me.Range("E27") Set rng4 = Me.Range("B6") cond1 = (UCase(rng3.Value) <> "SHANE") cond2 = Not IsEmpty(rng4) If Not Intersect(rng4, Target) Is Nothing Then [8:19].EntireRow.Hidden = wf.And(cond1, cond2) End If Greg [/QUOTE]
Verification
Post reply
Home
Forums
Newsgroups
Microsoft Excel
Microsoft Excel Programming
simple code hide/show rows with cell = empty, set value or any val
Top
