United States (English)

Home Library Learn Samples Downloads Support Community Forums

MSDN Library

Office and SharePoint development

Office client development

Office XP

Office XP

VBA Language Reference

Microsoft Office Web Components Object Models

Methods

B-C

BeginObject Method

BeginUndo Method

BorderAround Method

Calculate Method

CalculateFull Method

Clear Method

ClearContents Method

ClearFormats Method

Collapse Method

Copy Method

CopyFromRecordset Method

Cut Method

Minimize

This topic has not yet been rated - Rate this topic

ClearContents Method

Office XP

Deletes all data from the specified range.

expression.ClearContents

expression An expression that returns a Range object.

Example

This example deletes all data from cells A4:B10 on the active worksheet in Spreadhseet1.

Spreadsheet1.ActiveSheet.Range("A4:B10").ClearContents

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

© 2013 Microsoft. All rights reserved.