Clear spreadsheet cells format
 

I would like to clear all the cells format on the same spreadsheet.
Are there any worksheet function to do this?

Any information is great appreciated,

Clear spreadsheet cells format
 

Hi Souris,

Try:

Sub Test
Cells.Style = "Normal"
End sub


---
Regards,
Norman



"Souris" wrote in message
...
I would like to clear all the cells format on the same spreadsheet.
Are there any worksheet function to do this?

Any information is great appreciated,

Clear spreadsheet cells format
 

Cells.ClearFormats
in code.
--
steveB

Remove "AYN" from email to respond
"Souris" wrote in message
...
I would like to clear all the cells format on the same spreadsheet.
Are there any worksheet function to do this?

Any information is great appreciated,