Referring to Cells by Using Shortcut Notation [Excel 2003 VBA Language Reference]
You can 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.
Sub ClearRange()
Worksheets("Sheet1").[A1:B5].ClearContents
End Sub
Sub SetValue()
[MyRange].Value = 30
End Sub
See Also | Referring to Cells by Using a Range Object | Referring to Cells Relative to Other Cells | Referring to Named Ranges