sizing columns in code

J

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
 
C

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
 
J

JulieD

Hi Chip

thanks, worked perfectly

Cheers
julieD

Chip Pearson said:
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
Click to expand...
 
Top