Refer to Cells by Using Shortcut Notation

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

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.