Excel change font size automatically if too many characters

I have a cell that I want to change font size to be as large as possible to fill cell height.
But, I want the font size to change when I have more characters.
Example.... I want cell height and width to maintain, but there are too many characters.
So, we need to reduce font size.  (I am using column C for the data, and the putting in column A by =C3)
cell size cannot change, but I want to change font size automatically
Hope this makes sense.
Thanks
chris pikeAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Subodh Tiwari (Neeraj)Connect With a Mentor Excel & VBA ExpertCommented:
Maybe this......

Sub SetFontSizeToAutofit()
With Range("A:A")
   .WrapText = False
   .ShrinkToFit = True
End With
End Sub

Open in new window

0
 
chris pikeAuthor Commented:
Works for me. Thanks
0
 
ProfessorJimJamCommented:
Good one Neeraj.
1
 
Subodh Tiwari (Neeraj)Excel & VBA ExpertCommented:
You're welcome Chris! Glad to help.
0
 
Subodh Tiwari (Neeraj)Excel & VBA ExpertCommented:
@ Professor
Thanks for the appreciation. :)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.