But sometime the situation may arise where Excel table doesn’t expand for new data. When any new data enter in the worksheet then the Excel table automatically expand by default.

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. The active cell must be somewhere in the table before you run the example. The example selects the table without selecting the header row. This example assumes that you have a table on Sheet1 that has a header row. This example resizes the selection on Sheet1 to extend it by one row and one column. If this argument is omitted, the number of columns in the range remains the same. If this argument is omitted, the number of rows in the range remains the same. Resize ( RowSize, ColumnSize)Įxpression An expression that returns a Range object. You can select either a larger or smaller range, but The table headers will need to remain in the same row and the new table range must overlap the old table range.Įxpression. Use the range selector icon to select a new range. The Resize Table dialog box will pop up and you’ll be able to select a new range for your table. It is possible to use the Page Layout menu or Print Preview. As well as the width, can be adjusted the height. You can do it without changing font size or changing the width of each column. Setting the width of the table to one page is a common problem. Returns a Range object that represents the resized range. Set tbl = ActiveCell.CurrentRegion tbl.Offset(1, 0).Resize( - ).Select Support and feedback.

This example assumes that you have a table on Sheet1 that has a header row.

The Object that gets inserted is only big enough to show my first 4 columns, and trying to resize it just makes those 4 columns display in a larger size - rather than displaying any more of the table/scaling appropriately.

Resize excel table for mac