VBA for PAge Sizing - Need Help

[QualifiedOpinion]

So I am new to VBA. I found tins of stuff through the forums out on the web and thus have learned a ton so thanks.

I want 2 sheets in an excel model that are similiar (Income Stament and Balance Sheet) but are always a bit different. One might have 45 lines of data and the other one 60 and the next time around it might be switched in that one sheet would have 55 lines and the other 50 lines etc. I want a macro that set both to fit to 1 page tall and one page wide, then determine the zoom that this provides, then compare the zooms and set both to the lower zoom level so that both are the same and they always fit on 1 page. Is this possible?

 

[Toonies]

Hi you might want to check this out

http://www.mrexcel.com/forum/showthread.php?t=78453

hope it helps

Toonies