Hi

I'm creating an excel spreadsheet and want to adjust the columnwidth to the size of some text.

the line

.sheets(lnsheet).Columns(CHR(ncol+64 )+":"+CHR(ncol+64)).ColumnWidth=lncolwidth

works perfectly if I set excel to be visible.

But if I set excel to be not visible the same line gives me a type mismatch.

Any ideas why that is .

This is excel97 (be 10 years old soon)

Nick