Cells property (Excel Graph)
Returns a Range object that represents the cells in the specified range, as it applies to the Range object. Also, returns a Range object that represents all the cells on the datasheet (not just the cells that are currently in use), as it applies to the DataSheet object. Read-only Range object.
Syntax
expression.Cells
expression Required. An expression that returns a Range object.
Example
This example clears the formula in cell A1 on the datasheet. Note that on the datasheet, column A is the second column and row 1 is the second row.
myChart.Application.DataSheet.Cells(2,2).ClearContents
This example loops through cells A1:I3 on the datasheet. If any of these cells contains a value less than 0.001, the example replaces that value with 0 (zero).
Set mySheet = myChart.Application.DataSheet
For rwIndex = 2 to 4
For colIndex = 2 to 10
If mySheet.Cells(rwIndex, colIndex) < .001 Then
mySheet.Cells(rwIndex, colIndex).Value = 0
End If
Next colIndex
Next rwIndex
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.
Feedback
https://aka.ms/ContentUserFeedback.
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see:Submit and view feedback for