I need a macro that will hide rows that are either blank or have the number 0 in them. I need it to be passed a range as a parameter and only hide rows that match those two criterion inside that range.
something like
Sub HideRows(myRange as Range)
...code
End Sub
I know it is not too difficult, but I have not been able to accomplish it. I have found other similar examples but generally get caught by using a Range as a parameter or getting it to consider both blank cells and "0" cells as criteria. I would sincerely appreciate any help.
Thanks!
Bookmarks