Bold and formated cell wnat to delete in one stroke
 

I want to select all high lighted cells (with Bold font or cell formatted
with any color) in selected range. With one stroke. Becuase i want to delete
all Bold and formatted cells.

Bold and formated cell wnat to delete in one stroke
 

You can download the ASAP Utilities for free and install it ( add in ) then
select SELECTCONDITIONAL SELECT CELLS

http://www.asap-utilities.com/downlo...-utilities.php
Or go to Andrews and you can get info on codes for this too
http://www.andrewsexceltips.com/menu.htm


I want to select all high lighted cells (with Bold font or cell formatted
with any color) in selected range. With one stroke. Becuase i want to delete
all Bold and formatted cells.

Bold and formated cell wnat to delete in one stroke
 

range("a2:z22").Font.Bold = False



--
Don Guillett
SalesAid Software

"Qazi Ahmad" wrote in message
...
I want to select all high lighted cells (with Bold font or cell formatted
with any color) in selected range. With one stroke. Becuase i want to
delete
all Bold and formatted cells.

Bold and formated cell wnat to delete in one stroke
 

Sub Cleanup()
Dim rng As Range
For Each rng In Selection
If rng.Font.Bold = True Or rng.Interior.ColorIndex _
< xlNone Then
rng.ClearContents
rng.ClearFormats
End If
Next rng
End Sub


Gord Dibben MS Excel MVP

On Wed, 10 Jan 2007 21:46:01 -0800, Qazi Ahmad
wrote:

I want to select all high lighted cells (with Bold font or cell formatted
with any color) in selected range. With one stroke. Becuase i want to delete
all Bold and formatted cells.