Simply setting the column width in Excel with VBA

[BluByU]

I've done a forum search, but none of the topics seems to have a solution that works. I simply need to set the ".columnwidth" property of a spreadsheet to a certain width. I tried "autofit" (which is preferable to me)that also didn't seem to work. Here is what I am doing in VBA:

ThisWorkbook.Worksheets(2).Columns("A1:CZ500").EntireColumn.ColumnWidth = ??

Where "??" is the column width. None of the things I've tried seems to have any effect. Thanks in advance for your help.

 

[IknowMe]

Worksheets("Sheet1").Columns("A:I").AutoFit


Wow, I'm having amnesia and deja vu at the same time.
I think I've forgotten this before.

 

[PHV]

And what about this ?
ThisWorkbook.Worksheets(2).Columns("A:CZ").AutoFit

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[IknowMe]

or if you know what size you want it

Worksheets("Sheet1").Columns("A").ColumnWidth = 10

<- can't believe how quick PHV is on the draw

Wow, I'm having amnesia and deja vu at the same time.
I think I've forgotten this before.

 

[BluByU]

Thanks a lot! That fixed it. I guess the "row" numbers must have been confusing Excel. This is a great forum!