autofit problem

  • Thread starter Thread starter Gary Keramidas
  • Start date Start date
G

Gary Keramidas

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?
 
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.
 
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 said:
no luck with that, either, i have tried 20 in the past, but never 255.
 
yes, 255 failed, it seems to autofitting on the column header in row 1, not any
of the values below it. is this normal?
 
Not that I've seen.

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

I was hoping you two would come up with a reason for the non-autofit.
I have seen this occur for no apparent reason and in critical? code have
resorted to manually setting columns widths...

For x = 1 to 10
Worksheets(2).Columns(x).ColumnWidth = _
Worksheets(1).Columns(x).ColumnWidth
Next

Regards,
Jim Cone
San Francisco, USA


Not that I've seen.
 
And depending on the version of excel, you could
copy|paste special|columnwidths.

Maybe searching for #### would be a good way to go, too. Then widen that column
a bit, then a bit more, then...

(As long as there are no negative date/times and no real ###'s in the cell!)

I think I saw one of those routines in the eee newsletter on John Walkenbach's
site:
http://www.j-walk.com/ss/excel/eee/

But I didn't see it in a quick glance.
 
Dave,

Good memory.
I printed out the entire EEE letter several years ago.
Just took a look, it is in Chapter 9 with a short piece of code by John Green...
...
If IsNumeric(rng.Value) and Left(rng.Text,1) = "#" then
...

Regards,
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware


And depending on the version of excel, you could
copy|paste special|columnwidths.

Maybe searching for #### would be a good way to go, too. Then widen that column
a bit, then a bit more, then...

(As long as there are no negative date/times and no real ###'s in the cell!)

I think I saw one of those routines in the eee newsletter on John Walkenbach's
site:
http://www.j-walk.com/ss/excel/eee/

But I didn't see it in a quick glance.
 
That's the one!

I used the search (for #### and for width and for columnwidth), but never got a
hit. Hmmm.
 
looks like u substarct 2 dates and result is negative,- gives a lot of #####


"Dave Peterson" skrev:
That's the one!

I used the search (for #### and for width and for columnwidth), but never got a
hit. Hmmm.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top