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

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" wrote in message
...
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

Hi Chip

thanks, worked perfectly

Cheers
julieD

"Chip Pearson" wrote in message
...
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" wrote in message
...
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