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
Hide blank rows in a range
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
Reply to thread
Message
[QUOTE="trussman, post: 5988876"] Hello, This code works but, I want to hide rows within this range (rows 5:154) only Sub HideBlankRows() Dim RngCol As Range Dim i As Range Set RngCol = Range("A1:A20", Range("A" & _ Rows.Count).End(xlUp).Address) For Each i In RngCol If i.Value = "" Or i.Value = "*" Then i.EntireRow.Hidden = True Next i End Sub Thanks in advance for the help Marc [/QUOTE]
Verification
Post reply
Forums
Archive
Newsgroup Archive
Excel Newsgroups
Excel Programming
Hide blank rows in a range
Top
