sort by bold?
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)
"Joe Murphy" wrote in message
...
Anyone have a macro that will allow me to sort by whether a cell is bold
or
not? Using Excel2003.
Thanks,
JM
|