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