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