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,

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,

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,