Macro to Hide/Unhide rows with a strikethrough format in a cell in column A.

[intern91]

Hi all,

I have an internal document register with over 2000 rows, some of these documents are not valid anymore so they have strikethroughs, however they are required to stay in the register for reference. I am generally adept at VBA but I'm not sure where to start regarding a macro based on cell formatting. I have also conducted a google search and was not able to find something to aid me through the multiple forums.

If this has been posted and resolved in another place, I apologies for posting the same problem and would be grateful if you could direct me to it.

It would be preferable to conduct this with a macro rather than manually as I'm sure you all understand.

Excel 2010

intern91

[artiszta]

Hi Intern,

something like that?

Please Login or Register  to view this content.

Cheers

[intern91]

Thank you artiszta worked brilliantly, going to make working on this document a lot easier.

I added

Please Login or Register  to view this content.

to stop the screen from spazzing out.