Hi Folks

I'm trying to use the autofit method on a cell range using VBA, however, it seems to have no effect.

Consindering rows, the problem seems to be the same as if doing a double-click on the header between rows...sometimes it does autofit and other times not. So, I'd like to understand why it doesn't auto-adjust to the needed height at times, while it does work sometimes.

My guess is that once the row height in question has been set, there is no way back; and then the autofit method gets useless. but i'm hoping someone will tell me i'm wrong