Resizing a Workbook

[agc3278]

I have a workbook with code that hides rows when I input a number in a designated cell. The print size is set to fit the the worksheet on one page. Is it possible to have a macro that would resize the info based on what is visible on the worksheet? i.e. The more rows with data I have would appear smaller then if I only had 10 rows visible.

Any assistance would be greatly appreciated!

 

[dermie_72]

I have a workbook with code that hides rows when I input a number in a designated cell. The print size is set to fit the the worksheet on one page. Is it possible to have a macro that would resize the info based on what is visible on the worksheet? i.e. The more rows with data I have would appear smaller then if I only had 10 rows visible.

Any assistance would be greatly appreciated!

As the size increases, the data appears smaller...doesn't the fit to one page do that already?