I'm looking to hide all rows in my spreadsheet where a range of cells within that row are blank. The criteria must be that 5 cells in that row must be blank in order to hide that row.
I've looked at the following topic which has been solved but having trouble replicating for my needs:
http://www.excelforum.com/excel-prog...are-blank.html
The range of cells is from I > M that must be blank. If one of these cells in a row contains a value then I don't want to hide it.
Can you please help look at the above and suggest where I am going wrong.
Also having trouble pasting one macro into another - whats the best way to import?
Kind Regards
Alex
Bookmarks