View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Roy Roy is offline
external usenet poster
 
Posts: 53
Default Delete bolded items in column

Annette,

This simple test worked to delete BOLD formatted cells in column A, rows
1-26 on the Active Sheet. You could subtutute your own looping device.

For x = 1 To 26
If Cells(x, 1).Font.Bold = True Then
Cells(x, 1).Value = ""
End If
Next

Roy

"Annette" wrote:

How would I delete any items in, say column G, through a macro. I'm finding
I have to manually delete items and it would save time to do this through a
macro.

Thanks!

Annette