Hi,
In Excel I can click on "Table Design", "Resize Table" and amend "=$B$23:$O$72" to "=$D$23:$O$72".
I've searched but can't find VBA code for this (note that columns are fixed but number of rows in the table is dynamic and will change each time therefore any code would need to account for that).
I want to remove columns B & C from the table range in order that some non-table formatting can be applied to columns B & C (this is for a Public Sub that first populates the table).
Thanks in advance for any help you can give on this.
Bookmarks