Excel Reference

Refer to Cells by Using Shortcut Notation

Direct Answer

Refer to Cells by Using Shortcut Notation
is part of the Excel VBA object model. This reference page documents its syntax, parameters, and typical usage.

Reference

Use either the A1 reference style or a named range within brackets as a shortcut for the Range property. You don’t have to type the word “Range” or use quotation marks, as shown in the following examples.

“`vb
Sub ClearRange()
Worksheets(“Sheet1”).[A1:B5].ClearContents
End Sub

Sub SetValue()
[MyRange].Value = 30
End Sub
“`

!include[Support and feedback]

Reference: Excel object-model documentation • updated 06/08/2017
. Rebuilt for readability; see the original for complete parameter matrices.