VBA hide row with strikethrough

Dear knowledgeable EF users,

I am currently able to find and replace formatting of cells using the FindFormat function. However, I need the output of this function to hide rows. Does anybody here have a solution?

Please Login or Register  to view this content.

Does this help?

Please Login or Register  to view this content.

Hi John,

Yes, it certainly does help (with a bit of tweaking in my own code). Thanks very much. It is however a bit slow. Perhaps this is because the sheet it has to go through is nearly 1000 rows long and 22 cells wide? What do you think?

FYI, this is what the code looks like now:

Please Login or Register  to view this content.

Try:

Please Login or Register  to view this content.