Is there a way to have a table increase it's size using a Named Range that is dynamic.
I have a table that I would like to increase and decrease based on the size of a pivot table next to it.
I have named a range "MyRange" using the Offset method, that reflects the correct size.
When I created the table I put in MyRange and it correctly set up the table. However it does not change when my pivot table changes (Although the Named Range does.
Is there a way I can use VBA and the resize property, or better yet I wish I could do it in Excel.
Bookmarks