How many columns are you looking at and is it if the whole line isn't bold or
if certain cells on the row aren't bold?

"MrAle" wrote:


Hello,

I need to create a macro that removes all rows with none bold text.
Text can be in any cell.

Down below is a macro I created, but it only removes if the selected
cell contains none bold stuff.

I'm kinda new to VBA so a working macro would be greate!
Thanks

++++++++++++++++++++++++++++
Sub Testi()

On Error GoTo quit
If Selection.Font.Bold = False Then
Selection.EntireRow.Delete
End If

quit:

End Sub
++++++++++++++++++++++++++++


--
MrAle
------------------------------------------------------------------------
MrAle's Profile: http://www.excelforum.com/member.php...o&userid=26868
View this thread: http://www.excelforum.com/showthread...hreadid=401073