Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Default Cell Formatting
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.? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Default Cell Formatting
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.? If it's the active cell.... ActiveCell.Clear If it's a range... Range("A4:K12").Clear Rick |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Default Cell Formatting
Cells.clear
should work, if it doesnt, you could record a macro while setting up a cell the way you want and use that. hth carlo |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Default Cell Formatting
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.? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Default values for cell formatting and Pivot tables | Excel Discussion (Misc queries) | |||
Default formatting for charts | Charts and Charting in Excel | |||
Setting default formatting | Setting up and Configuration of Excel | |||
Default formatting | Charts and Charting in Excel | |||
How do I change the default cell formatting to be text? | Excel Discussion (Misc queries) |