James Patterson is the #1 New York Times bestselling author of many books, including the blockbuster series MAXIMUM RIDE. More than 100 million of his books are in print around the world, making him one of the top-selling writers of all time.
You can refer a name range in VBA code like below: Range(â<range name>â) Above statement returns a 2 dimensional array which is holding all the values in the named range in (x, y) format where x = Row, y= Column. Note: If named range is having only one cell then Range(â<range name>â) will return that one value.
In many situations, your VBA procedure needs to work with a range that can vary in size. For example, you may have a worksheet that holds weekly sales data. Every week you add a new row to it. Creating a VBA procedure to manipulate the data can be tricky, since the size of the range will vary from week to week. This document describes a number of VBA techniques that are useful when working with ranges that have an unknown size.