Data Filter

[MikeyZ]

Is there a way to use the Data Filter or whatever, when you've used the Strikeout feature in a cell?


Otherwise I will have to resort to sorting by Colors.

 

[Andrew Poulsom]

You could use this UDF:

Function Struckthrough(Cell As Range)
    Struckthrough = Cell.Font.Strikethrough
End Function

in a cell like:

=Struckthrough(A1)

and filter that column for TRUE.

 

[MikeyZ]

I will try it, but I'm
Not sure where to use your suggestion!!

 

[Andrew Poulsom]

Press Alt+F11 to go to the Visual Basic Editor. Click your workbook in the Project window and choose Insert|Module from the menu. Copy my function from the Board and paste it into the window on the right. Close the VBE and try it out.

 

[MikeyZ]

I've decided to color code. It will filter better.
I failed to tell you that the array with the strickouts is from A1:E200.

Thanks as always for your help.

Mike