Set Col width on SpreadsheetCtl 9.0???

Steff_DK · Oct 25, 2005

I have an MS Office Spread sheet 9.0 control on a form (since the flexgrid wasn't available

)

How do I set the individual column width?

Have tried:

Code:

SpreadsheetCtl.Columns(5).Width = 3
SpreadsheetCtl.Columns("D:D").ColumnWidth = 3
SpreadsheetCtl.Columns("D:D").Width = 3

Doesn't work

This one I even recorded in a macro in Excel...

Code:

SpreadsheetCtl.Columns("D:D").ColumnWidth = 3

Thanks everyone

Steff_DK · Oct 25, 2005

The plot thickens...

I get a msgbox with correct content (the width) when I do;

Code:

Msgbox SpreadsheetCtl.Columns(5).Width

If I delete the msgbox part I get wrong number of args or invalid property for that object ...

Still clueless