IF cell contains ANYTHING then hide the entire row
Tried to use the macro recorder, turn on filtering and leave the blanks visible - but it would not allow me to --
Need a simple Sub to perform this task on my "active sheet" (don't want to hardcode in a specific sheet name to use generically)
IF Column "I"
(starting with row 2 down) contains ANYTHING then hide entire row.
(currently that column holds dates with headers in row 1:1) but hoping the code can be generic (not hard coded to look for dates)
Sub t() With ActiveSheet.Range("I2", Cells(Rows.Count, "I").End(xlUp)) .SpecialCells(xlCellTypeConstants).EntireRow.Hidden = True End With End Sub
Last edited by JLGWhiz; 02-17-2018 at 09:15 PM.
Any code provided by me should be tested on a copy or a mock up of your original data before applying it to the original. Some events in VBA cannot be reversed with the undo facility in Excel. If your original post is satisfied, please mark the thread as "Solved". To upload a file, see the banner at top of this page.
Just when I think I am smart, I learn something new!
That's it! Awesome -- thanks greatly!
REPUTATION points given
You're welcome and thanks for the reps.Originally Posted by CHRISOK
That's it! Awesome -- thanks greatly!
REPUTATION points given
Regards, JLG
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks