sizing columns in code

[JulieD]

Hi All

i'm having a really hard time sizing columns in code ... i've tried writing
the code myself /i've tried recording it and nothing seems to work .. very
simply i want column A to be 10, B to be 40, C to be 20, D & E & F & G & H
to be 15 & I to be 40 ... how do i do it???

the text in these columns also needs to word wrap.

Using Excel 2000 (but i can't get it to work on 2002 or 2003 either).

Cheers
julieD

 

[Chip Pearson]

Julie,

Try something like

Columns(1).ColumnWidth = 10
Columns(2).ColumnWidth = 40
' etc


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[JulieD]

Hi Chip

thanks, worked perfectly

Cheers
julieD

Julie,

Try something like

Columns(1).ColumnWidth = 10
Columns(2).ColumnWidth = 40
' etc


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com