Boundaries of a Range Object (SAP-Bibliothek - SAP Automation RFC and BAPI Interfaces (BC-FES-AIT))

Boundaries of a Range Object

The boundaries of a Range object can be set in two ways:

by using the parameters of the Add method on a Ranges collection object

by setting the bounds explicitly with the LowerBound, UpperBound, LeftBound, or RightBound properties

All boundaries are checked against the underlying Table object. An OLE exception is triggered if a bound exceeds the corresponding table dimension.

Dim oRange as Object
Dim oTable as Object
Rem 1. Set the Boundaries through the properties
Set oRange = oTable.Ranges.Add
oRange.LowerBound = 2
oRange.UpperBound = 4
oRange.LeftBound = 2
oRange.RightBound = 4
Rem 2. Set the Boundaries via the Ranges.Add method
Set oRange = oTable.Ranges.Add ( 2,4,2,4)