expression.Range
expression Required. An expression that returns an object in the Applies To List.
For information about returning a single member of a collection, see Returning an Object from a Collection.
Example
This example clears column A of the datasheet.
myChart.Application.DataSheet.Columns(2).ClearContents