'Declaration Public Overloads Sub Resize( _ ByVal headerAndDataRegionAddress As String _ )
public void Resize( string headerAndDataRegionAddress )
Exception | Description |
---|---|
System.InvalidOperationException | Occurs when the WorksheetTable has previously been removed from the worksheet. |
System.ArgumentNullException | Occurs when headerAndDataRegionAddress is null. |
System.ArgumentException | Occurs when headerAndDataRegionAddress is not a valid name or a valid cell or region address in the workbook's cell reference mode. |
System.InvalidOperationException | Occurs when headerAndDataRegionAddress is a relative R1C1 address. The overload taking an origin cell must be used to resolve relative R1C1 references. |
System.ArgumentException | Occurs when the top of the headerAndDataRegionAddress does is not the same as the top of the table. |
System.ArgumentException | Occurs when the headerAndDataRegionAddress does not contain at least one data row for the table. |
System.ArgumentException | Occurs when the headerAndDataRegionAddress does not overlap the current table region. |
System.InvalidOperationException | Occurs when the there is a merged cell, array formula, data table, or another table in the new region. |
If the totals row is visible, it will be placed below the last data row automatically. If the totals row is currently inside the new table region, it will be moved out to below the new data rows, which will be shifted up by one row.
Target Platforms: Windows 10, Windows 8.1, Windows 8, Windows 7, Windows Server 2012, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2