[SOLVED] Shrink text to fit in a cell using macro, Basic

[Vlatko]

Hello,
I want to set cell format “shrink text to fit in a cell” using a macro (Basic), but I cannot see how. Thanks in advance.

[Lupp]

The cell object has a Boolean property .ShrinkToFit .
myCellObject.ShrinkToFit = True should do what you want.

[Vlatko]

Thanks Lupp, it works