Home Library Learn Samples Downloads Support Community Forums
MSDN Library
Office and SharePoint development
Office client development
Office 2007
Excel 2007
Excel 2007 Developer Reference
Excel Object Model Reference
Range Object
Methods
Activate Method
AddComment Method
AdvancedFilter Method
ApplyNames Method
ApplyOutlineStyles Method
AutoComplete Method
AutoFill Method
AutoFilter Method
AutoFit Method
AutoOutline Method
BorderAround Method
Calculate Method
CalculateRowMajorOrder Method
CheckSpelling Method
Clear Method
ClearComments Method
ClearContents Method
ClearFormats Method
ClearNotes Method
ClearOutline Method
ColumnDifferences Method
Consolidate Method
Copy Method
CopyFromRecordset Method
CopyPicture Method
CreateNames Method
Cut Method
DataSeries Method
Delete Method
DialogBox Method
Dirty Method
EditionOptions Method
ExportAsFixedFormat Method
FillDown Method
FillLeft Method
FillRight Method
FillUp Method
Find Method
FindNext Method
FindPrevious Method
FunctionWizard Method
GoalSeek Method
Group Method
Insert Method
InsertIndent Method
Justify Method
ListNames Method
Merge Method
NavigateArrow Method
NoteText Method
Parse Method
PasteSpecial Method
PrintOut Method
PrintPreview Method
RemoveDuplicates Method
RemoveSubtotal Method
Replace Method
RowDifferences Method
Run Method
Select Method
SetPhonetic Method
Show Method
ShowDependents Method
ShowErrors Method
ShowPrecedents Method
Sort Method
SortSpecial Method
Speak Method
SpecialCells Method
SubscribeTo Method
Subtotal Method
Table Method
TextToColumns Method
Ungroup Method
UnMerge Method
Expand Minimize
This topic has not yet been rated - Rate this topic

Range.ClearFormats Method

Office 2007
Clears the formatting of the object.

Syntax

expression.ClearFormats

expression   A variable that represents a Range object.

Return Value
Variant

Example

This example clears all formatting from cells A1:G37 on Sheet1.

Visual Basic for Applications
Worksheets("Sheet1").Range("A1:G37").ClearFormats

This example clears the formatting from embedded chart one on Sheet1.

Visual Basic for Applications
Worksheets("Sheet1").ChartObjects(1).Chart.ChartArea.ClearFormats

See Also


Did you find this helpful?
(1500 characters remaining)

Community Additions

ADD
© 2013 Microsoft. All rights reserved.