Shortcut Range References

You can also refer to a range by enclosing an A1 style range reference or a name in square brackets, which is a shortcut form of the Evaluate method of the Application object. It is equivalent to using a single string argument with the Range property, but is shorter:

[A1:A10,C1:C10,E1:E10] [SalesData]

This shortcut is convenient when you want to refer to an absolute range. However, it is not as flexible as the Range property, because it cannot handle variable input as strings or object references.

0 0

Post a comment