Clear spreadsheet cells format

[Souris]

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,

[Norman Jones]

Hi Souris,

Try:

Sub Test
Cells.Style = "Normal"
End sub


---
Regards,
Norman



"Souris" <Souris@discussions.microsoft.com> wrote in message
news:8D7E0D4E-4969-4A3C-858B-F4B632065EB1@microsoft.com...
>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,

[STEVE BELL]

Cells.ClearFormats
in code.
--
steveB

Remove "AYN" from email to respond
"Souris" <Souris@discussions.microsoft.com> wrote in message
news:8D7E0D4E-4969-4A3C-858B-F4B632065EB1@microsoft.com...
>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,