LinkBack URL
About LinkBacks
Seler Naciowy 
You can't imagine how Delighted I am that it doesn't :> Just the fact I have to deal with it makes me feel nauseous....Well it doesn't seem to ;-)
You can't imagine how Delighted I am that it doesn't :> Just the fact I have to deal with it makes me feel nauseous....Well it doesn't seem to ;-)
This will hide all rows that have blank cells in C or D
Dim rng As Range Set rng = Range(Cells(2, 3), Cells(Rows.Count, _ 4).End(xlUp)).SpecialCells(xlCellTypeBlanks) rng.EntireRow.Hidden = True
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
Hi Roy,
I have no problem with Hiding the data, I have a problem with extracting data to another sheet based on criteria of the filter. Hiding it doesn't make much of a difference, you know.
Hi arthurbr,
I wouldn't feel entirely comfortable posting the data for the whole world wide web to see - while it's not strictly confidential, it is rather sensitive. Would it be ok with you if I sent it to you via email?
Cheers,
Seler
Hi Guys,
Just so you know - I managed to resolve it by adding following piece of code into the macro:
This searches for all empty cells in colums B and C of the data in the filter results and deletes entire row if an empty cell is found.Columns("B:C").Select Selection.SpecialCells(xlCellTypeBlanks).EntireRow.Delete
a bit of an overkill, but works...
Cheers,
Seler
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks