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.
VBA-Excel: Array Functions â LBound and UBound() LBound and UBound() FuncÂ­tions returns the startÂ­ing index ( Lower Bound) and EndÂ­ing index (Upper Bound) of an array. If an array is one dimenÂ­sional then no need to proÂ­vide this arguÂ­ment but if it is Two or Multi dimenÂ­sional array then you need to proÂ­vide the dimenÂ­sion as well for which you want lower or upper bound. Related Posts: