Another one -

Activesheet.Range("A1").ClearFormats

What both .Clear and .ClearFormats actually do is apply the workbook's
Normal style (Formats / Styles).

In a new workbook based on the default template, the Normal style's font is
set from -
Application.StandardFont & .StandardFontSize (Tools / Options / General).
After changing these settings, manually or programmatically, need to restart
Excel for them to take effect.

Regards,
Peter T

"scott" wrote in message
...
What vba code will format a cell back to Excel's default formatting with
the
default borders, clear/white background, arial 10 font, normal text, etc.?