Excel 2007 Crasher in one Immediate Windo Line

[Roopher]

Hello!

I just have discovered a surefire way to crash my Exel 2007:

Trying to change the .ColumnWidth of 3 columns at once, I receive strange behaviour, and a subsequently forever-looping application. In the immediate window I type:

Activesheet.Columns("A:C").ColumnWidth=Array(5,15,50)

Can someone confirm this? Or better give me a fix for it? At least the three columns do have the desired widths when I run the line...


Thanks!

 

[Roopher]

Re: Excel 2007 Crasher in one Immediate Window Line: No one?

No one had a go with the statement I posted? Craving feedback, since I'd love to use that line in my code!

...is this line working as expected on you machine?

Activesheet.Columns("A:C").ColumnWidth=Array(5,15,50)

Thank You again!

 

[Andy Pope]

Not restricted to xl2007. Same thing in xl2003.
At a guess I would say it is setting the column width for each row in the sheet, which is giving the looping affect.

This appears to work.

Activesheet.Columns("A:C").rows(1).ColumnWidth=Array(5,15,50)

 

[Roopher]

Yes, Andy, it's working now for me too. Now I can save 5 unneccesary lines of code to loop those colums Thank You very much!