sort by bold?

[Joe Murphy]

Anyone have a macro that will allow me to sort by whether a cell is bold or
not? Using Excel2003.

Thanks,
JM

 

[Bob Phillips]

Joe,

You need a helper column, and use a UDF to determine if bold

Function IfBold(rng As Range)
IfBold = rng.Font.Bold = True
End Function

and in the adjacent column use

=IfBold(A1) and copy down.

Then sort on that column.

--

HTH

RP
(remove nothere from the email address if mailing direct)