Macro for Hide blank rows and Unhide the rows with cells

Hi Experts,

I am looking for the macro for column B from Cell B1 to Cell 105 (Sheet Name is "Report 1 (CY)") where i have put the formulae but if the error found by the formula then it would be shown as blank and i would like to hide those blank rows unless the text is not appeared but if the text appears in those rows then it should unhide. Request to you kindly do provide the requested macro.

thank you for your precious phase and valuable support.

Regards,

Neilesh

Hi
this macro hides all rows in the specified range where that row's value in column B is either an error or a blank

Please Login or Register  to view this content.

Originally Posted by NickyC

Hi
this macro hides all rows in the specified range where that row's value in column B is either an error or a blank

Please Login or Register  to view this content.

Dear Expert,

Thank you so much for your precious support, but the provided macro is hiding the blank rows and i do required both hide the blank rows and unhide as well to the blank rows. Request to you please help me out.

Thank you for your precious phase and valuable support.

Regards,

Neilesh

Originally Posted by NickyC

Hi
if you do not want to hide blank rows then try this

Sub hide_errors()
Dim CCell As Range, MyRange As Range
Set MyRange = Sheets("Report 1 (CY)").Range("B1:b105")
MyRange.Rows.Hidden = False
For Each CCell In Range("B1:B105").Cells
On Error Resume Next
If IsError(CCell) Then CCell.Rows.Hidden = True
Next CCell

Thanks a ton Sir. Thanks a lot.