>For what it is worth
>
>(1) You do the autofit after all rows have been filled out, I take it
>
>(2) I'm using another 'autofit'. Do not know whether it makes a difference
>
>xlSheet.PageSetup.PrintTitleRows = "$1:$1"
>for i = 1 to m.ncols
>
> =m.xlSheet.Columns(m.i).EntireColumn.AutoFit
>endfor
>
May be EntireColumn can make a difference, but I doubt. I played with the file in Excel itself and trying to autofit didn't make the column width correct.
Anyway, I'm going to give it a shot. See my other response for the latest "formula" I use.
If it's not broken, fix it until it is.
My Blog