I have a sheet with many pivot tables on it I use for pivot charts. When I
update the pivot table the table expands and bumps into the next table on the
sheet. I have the tables listed vertically on the sheet. The tables are
going to expand vertically by month so I know I could just insert 12 or so
lines between each pivot table but I figure there must be a way to have a
macro insert a line after each pivot table before it updates all tables. I
have a macro built that refreshes all tables then fixes the formats on the
charts with the click of one button. My sheet with the tables is laid out
like this:

Table1
Columns of Sales Data
Month1
Month2

Table2
Columns of Sales Data
Month1
Month2

How can I tell it to look for the last row of the pivot table and then
insert a row? Or is there a better way to accomplish what I am trying to do
which is to insert a row instead of overwrite the row when the pivot table is
refreshed.

Thanks in advance for you help.