when i use autofit, in code or just clicking the column divider, it doesn't
always autofit all of the columns.

using this code
..Columns("A:Q").AutoFit

i sometimes have one column that displays some ###'s, in this case it was column
D. the column has actual numbers in it, not a formula.

and ideas?

--


Gary

What happens if you widen the columns as far as you can, then autofit?

With ActiveSheet
With .Columns("A:Q")
.ColumnWidth = 255
.AutoFit
End With
End With

Maybe it'll help.



Gary Keramidas wrote:

when i use autofit, in code or just clicking the column divider, it doesn't
always autofit all of the columns.

using this code
.Columns("A:Q").AutoFit

i sometimes have one column that displays some ###'s, in this case it was column
D. the column has actual numbers in it, not a formula.

and ideas?

--

Gary

--

Dave Peterson

no luck with that, either, i have tried 20 in the past, but never 255.

--


Gary


"Dave Peterson" wrote in message
...
What happens if you widen the columns as far as you can, then autofit?

With ActiveSheet
With .Columns("A:Q")
.ColumnWidth = 255
.AutoFit
End With
End With

Maybe it'll help.



Gary Keramidas wrote:

when i use autofit, in code or just clicking the column divider, it doesn't
always autofit all of the columns.

using this code
.Columns("A:Q").AutoFit

i sometimes have one column that displays some ###'s, in this case it was
column
D. the column has actual numbers in it, not a formula.

and ideas?

--

Gary

--

Dave Peterson

Does that mean you tried 255 and it failed?

If you know which columns need to be widened, you could always just add a little
to that columnwidth after autofitting.

with .columns("d")
.autofit
.columnwidth = .columnwidth + 2 'as small as you need
end with

Gary Keramidas wrote:

no luck with that, either, i have tried 20 in the past, but never 255.

--

Gary

"Dave Peterson" wrote in message
...
What happens if you widen the columns as far as you can, then autofit?

With ActiveSheet
With .Columns("A:Q")
.ColumnWidth = 255
.AutoFit
End With
End With

Maybe it'll help.



Gary Keramidas wrote:

when i use autofit, in code or just clicking the column divider, it doesn't
always autofit all of the columns.

using this code
.Columns("A:Q").AutoFit

i sometimes have one column that displays some ###'s, in this case it was
column
D. the column has actual numbers in it, not a formula.

and ideas?

--

Gary

--

Dave Peterson

--

Dave Peterson

yes, 255 failed, it seems to autofitting on the column header in row 1, not any
of the values below it. is this normal?

--


Gary


"Dave Peterson" wrote in message
...
Does that mean you tried 255 and it failed?

If you know which columns need to be widened, you could always just add a
little
to that columnwidth after autofitting.

with .columns("d")
.autofit
.columnwidth = .columnwidth + 2 'as small as you need
end with

Gary Keramidas wrote:

no luck with that, either, i have tried 20 in the past, but never 255.

--

Gary

"Dave Peterson" wrote in message
...
What happens if you widen the columns as far as you can, then autofit?

With ActiveSheet
With .Columns("A:Q")
.ColumnWidth = 255
.AutoFit
End With
End With

Maybe it'll help.



Gary Keramidas wrote:

when i use autofit, in code or just clicking the column divider, it
doesn't
always autofit all of the columns.

using this code
.Columns("A:Q").AutoFit

i sometimes have one column that displays some ###'s, in this case it was
column
D. the column has actual numbers in it, not a formula.

and ideas?

--

Gary

--

Dave Peterson

--

Dave Peterson

Not that I've seen.

Gary Keramidas wrote:

yes, 255 failed, it seems to autofitting on the column header in row 1, not any
of the values below it. is this normal?

--

Gary

"Dave Peterson" wrote in message
...
Does that mean you tried 255 and it failed?

If you know which columns need to be widened, you could always just add a
little
to that columnwidth after autofitting.

with .columns("d")
.autofit
.columnwidth = .columnwidth + 2 'as small as you need
end with

Gary Keramidas wrote:

no luck with that, either, i have tried 20 in the past, but never 255.

--

Gary

"Dave Peterson" wrote in message
...
What happens if you widen the columns as far as you can, then autofit?

With ActiveSheet
With .Columns("A:Q")
.ColumnWidth = 255
.AutoFit
End With
End With

Maybe it'll help.



Gary Keramidas wrote:

when i use autofit, in code or just clicking the column divider, it
doesn't
always autofit all of the columns.

using this code
.Columns("A:Q").AutoFit

i sometimes have one column that displays some ###'s, in this case it was
column
D. the column has actual numbers in it, not a formula.

and ideas?

--

Gary

--

Dave Peterson

--

Dave Peterson

--

Dave Peterson