setting row height not to exceed...

[Tina]

I need to have row height in an Excel spreadsheet to be auto fit, up
to a height of 105. If the row height exceeds 105, I want it to
remain at 105. Can that be programmed in VB? If so, what is the code?

 

[Gord Dibben]

See this thread for two VBA methods.

One manually run, the other event-driven.

http://tinyurl.com/4y2b952


Gord Dibben MS Excel MVP