ListObject.Resize(Range) Method

Reference

Definition

Namespace:: Microsoft.Office.Interop.Excel

Assembly:: Microsoft.Office.Interop.Excel.dll

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

The Resize method allows a ListObject object to be resized over a new range.

public:
 void Resize(Microsoft::Office::Interop::Excel::Range ^ Range);

public void Resize (Microsoft.Office.Interop.Excel.Range Range);

Parameters

Range: Range

Required 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.

Applies to