loop to check cell contains strikethrough/underline

[dweebz]

How do I create a code whereby it checks if the cell contains a strikethrough or underline (or both) then it does something, otherwise it wont, and will check the next cell.

[Trebor76]

Hi dweebz,

What range are you working with?

Robert

[dweebz]

The range I'm working with is from the first row of the last column, to the last row of the last column.

This is my code to colour strikethrough text blue and underlined text red, but it's really slow and i'm trying to find a way to optimise this process.

So i thought, if I include a feature where, if the cell does not contain a strikethrough nor underline, it will skip it and go to the next cell, therefore making it more efficient.

But I haven't figured out a way to integrate that sort of feature into my code below.

Please help

Please Login or Register  to view this content.

[Trebor76]

Try this:

Please Login or Register  to view this content.

Regards,

Robert