ListObject.Resize Method
The Resize method allows a ListObject object to be resized over a new range.
Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)
Syntax
'Declaration
Sub Resize ( _
Range As Range _
)
'Usage
Dim instance As ListObject
Dim Range As Range
instance.Resize(Range)
void Resize(
Range Range
)
Parameters
Range
Type: Microsoft.Office.Interop.Excel.RangeRequired Range.
Remarks
No cells are inserted or moved by this property.
This property returns Nothing.
For lists that are linked to a server that is running Microsoft Windows SharePoint Services, you can resize the list using this method by providing a Range argument that differs from the current range of the ListObject only in the number of rows it contains. Attempting to resize lists linked to Windows SharePoint Services by adding or deleting columns (in the Range argument) results in a run-time error.