How to remove ONLY formatting of a range of cells ... that is, leave the content in a tick

Question

I am trying to remove color from cells, but not data in cells. I have tried these 2 methods:

Sheets("Output").Range("B3:ka200").Clear
Sheets("Output").Range("B3:ka200").ClearContents

but both delete data. I need a method that will preserve the data and remove the formatting.

+3

nik 09 June At 9:53 am

2 answers

Range("A1:C4").Interior.ColorIndex = xlNone

This will remove the background color of the cell.

0

chinna_82 09 June At 9:57 am

99moorem · Accepted Answer · 2015-06-09T09:56:49+0000

Try

Sheets("Output").Range("B3:ka200").ClearFormats

Please note that all formatting will be removed above