PDA

View Full Version : clearing text without removing color



sathishesb
01-10-2011, 02:51 AM
Hi guys,
I tring to delete the content of a cell using,
.Range("G2:G4").clear

but it also delete's the background color in the cell. I need to delete only the content but not the filled colors..


Plzzzz help me:dunno

mancubus
01-10-2011, 02:57 AM
hi.


Range("A1:C500").ClearContents