sorting by data that has strikethrough in it

Taylor_Jr · Feb 17th, 2002, 08:05 PM

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

Juan Pablo González · Feb 17th, 2002, 08:08 PM

Paste this UDF in a module.

Code:

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 · Feb 17th, 2002, 08:26 PM

Thanks, Worked very nicely.

Thanks Again

Feb 17th, 2002, 08:08 PM	#2
Juan Pablo González MrExcel MVP Join Date: Feb 2002 Location: Bogota, Colombia Posts: 11,927	Paste this UDF in a module. Code: 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. __________________ Regards, Juan Pablo González http://www.juanpg.com

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Feb 17th, 2002, 08:05 PM	#1
Taylor_Jr New Member Join Date: Feb 2002 Posts: 4	How do you sort out rows that have been completely strickenthrough with strikethrough?

Feb 17th, 2002, 08:26 PM	#3
Taylor_Jr New Member Join Date: Feb 2002 Posts: 4	Thanks, Worked very nicely. Thanks Again