How to: Refer to Cells by Using Shortcut Notation

Last modified: June 30, 2011

Applies to: Excel 2013 | Office 2013 | VBA

You can use either the A1 reference style or a named range within brackets as a shortcut for the Range property. You do not have to type the word "Range" or use quotation marks, as shown in the following examples.

Sub ClearRange() 
 Worksheets("Sheet1").[A1:B5].ClearContents 
End Sub 
 
Sub SetValue() 
 [MyRange].Value = 30 
End Sub
Show:
© 2015 Microsoft