should be simple - setting Excel column widths

[jender624]

What is the correct syntax for setting the column width of an excel worksheet object?

I've been trying this:

wsSheet.Columns(0).ColumnWidth = 100

but keep getting an application defined or object defined error.

Thanks,

jender624

 

[LNBruno]

Did you remember to reference the Excel object (can't tell you how many times I've been bitten by that one!)?

< M!ke >

 

[jender624]

AAAAAARRRGGG, I'm dumb. I'm sorry, I forgot I put an autofit at the end of my procedure. I actually was doing it right originally, but any changes in width were wiped out by the autofit, which I didn't realize. Sorry to have wasted your time.

Thanks anyway!

jender624