I’m going to show you how you can resize an existing Excel table. Let’s assume you have the following table in excel (A1:C6): And you want to resize the table to a table like this (A1:C10CN): Here are the steps that need to be performed: - Update the SheetDimension to A2:CN. Hi @NivedNambiar. I am able to append data in excel like for eg there are already 2 rows in the excel and I am able to add 3 more rows till index 5 rows, but there is a table in excel, that table size remains the same till 2 rows, and that table as some formulas, so I need to change the table last row till newly added last index row.
The Resize method allows a ListObject object to be resized over a new range. No cells are inserted or moved.
Syntax
expression.Resize (Range)
expression An expression that returns a ListObject object.
Parameters
| Name | Required/Optional | Data type | Description |
|---|---|---|---|
| Range | Required | Range | The new range. |
Remarks
For tables that are linked to a server that is running Microsoft SharePoint Foundation, 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 SharePoint Foundation by adding or deleting columns (in the Range argument) results in a run-time error.
Example
The following example uses the Resize method to resize the default ListObject object on Sheet1 of the active workbook.
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.
Setting the width of the table to one page is a common problem. You can do it without changing font size or changing the width of each column. As well as the width, can be adjusted the height. Let’s see how.
We are going to change scale. It is possible to use the Page Layout menu or Print Preview.
Page Layout
Go to the Page Layout menu on the Ribbon. There you find Scale to fit. By using the width or height can be changed the table size.
Print Preview
Display the Print preview. Select Page Setup and on the Scaling you can change Fit to x page(s) wide or x pages tall (height).
Resize Excel Table To Fit Into Word
Resize Excel Table Vba
How To Resize Excel Table In Word Document
Reading this makes my deisoicns easier than taking candy from a baby.