Page setup via VBA

[luvbite38]

Hi,

I have a dynamic table, the rows and the columns of the table gets added or deleted based on some calculation.

Is there a way, if the content of any page is less than a A4, potrait paper. that pages expends to better fit the page???

I tried the Fit Width and Height to 1 but the page is still looking fairly empty.

Is there another way that the row sizes increases for that particular page to fit on one page??

 

[vaskov17]

I think that would be based on the column width of the print area so you either would have to increase column width or font size. In either case that might make your print area larger than the paper size. If you could rearrange the way your data is displayed, you might have a solution.