Link to home
Start Free TrialLog in
Avatar of Dov_B
Dov_B

asked on

Ms excel vba : macro that will take the number of cells i need to fit on the page and automaicly size them to the largest possible

I am constantly wasting time tweeking the size of cells to get the number I need to fit on the page to fit. Is there a way to do this progrmaticly or is there an excel button for that?
Avatar of urthrilled
urthrilled

What version of Excel are you using?  Have you tried the Fit to Page option?
Avatar of Dov_B

ASKER

ms excel 2010
Avatar of Dov_B

ASKER

i am using ms excel 2010:where is that option found?
ASKER CERTIFIED SOLUTION
Avatar of urthrilled
urthrilled

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Dov_B

ASKER

Thanks but I dont think that is waht I amlooking for that will shrink things. I want something that perhaps should becalled resize to fit
Sorry, I don't know of any other way, other than fit to page.

Have you tried the Justified and Distributed settings?  I've never used them, but you might see if they will work for you.
Avatar of Dov_B

ASKER

where are they to be found?