Forums
New posts
Search forums
Members
Current visitors
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Search forums
Menu
Log in
Register
Install the app
Install
Forums
Archive
Newsgroup Archive
Excel Newsgroups
Excel Programming
Macro to hide rows based on criteria
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
Reply to thread
Message
[QUOTE="Jarek Kujawa, post: 6328296"] try to select yr data and use the macro: Sub hideeeee() On Error Resume Next For Each cell In Selection If IsNumeric(cell) And cell.Offset(0, 4) = 0 And cell.Offset(0, 5) = 0 Then cell.Rows.EntireRow.Hidden = True End If Next cell End Sub HIH [/QUOTE]
Verification
Post reply
Forums
Archive
Newsgroup Archive
Excel Newsgroups
Excel Programming
Macro to hide rows based on criteria
Top
