sorting by data that has strikethrough in it

[Taylor_Jr]

How do you sort out rows that have been completely strickenthrough with strikethrough?

 

[Juan Pablo González]

Paste this UDF in a module.

Function HasStrike(Rng As Range) As Boolean
HasStrike = Rng.Font.Strikethrough
End Function

Then, back in Excel, in a new column, use the formula like

=HasStrike(A1)

Where A1 is the cell that you're testing. Now, sort on this column.

 

[Taylor_Jr]

Thanks, Worked very nicely.

Thanks Again