Resizing table after data is pulled in

[sy898661]

Hello all!

I have a macro that pulls data from one table into another. I am using =sum for one column so when there are blank rows the calculated column returns #N/A which then does not allow the =sum function to work. I have included pictures for what I mean because when a larger data set is pulled in, the table resizes itself to be bigger but never to be smaller

But I was wondering what I should add to my code to resize the table after the data is pulled in?

Please Login or Register  to view this content.

[louvaek]

To resize to Autofit this can be added:

Please Login or Register  to view this content.

I picked F but you can adapt to necessary column(s)

[sy898661]

Oh, so easy!!! Thank you so much!

[sy898661]

Wait, actually when I plugged this in, it autofit the column width instead of the table length