Excel Reference

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.

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

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

!include[Support and feedback]

Other Refer members in Excel (8)

5 community Q&A using Refer to Cells by Using Shortcut Notation

Libraries that work with Refer (5)

57 wordsMicrosoft Docs rev. 06/08/2017