VB code to Reduce Font Size

[Gos-C]

Hi everyone,

Can someone help me with a VB code to reduce the font size of cell B6 from 10 to 8 if the content does not fit the column width. (I don't want the text to wrap - it must fit on one line.) Cell B6 contains a formula that copies another cell.

Thank you,
Gos-C

[antoka05]

You may try with ths code:

Please Login or Register  to view this content.

Regards,
Antonio

[Gos-C]

Hi Antonio,

It didn't work. Cells B6 to Q6 are merged. Would that make a difference?

Thanks,
Gos-C