| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
autofit problem
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
autofit problem
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
autofit problem
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
autofit problem
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
autofit problem
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 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
autofit problem
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 |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
autofit problem
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 "Dave Peterson" wrote in message ... 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 |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
autofit problem
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. Jim Cone wrote: 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 "Dave Peterson" wrote in message ... 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 |
|
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
autofit problem
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 "Dave Peterson" wrote in message ... 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. Jim Cone wrote: 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 "Dave Peterson" wrote in message ... 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 |
|
#10
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
autofit problem
That's the one!
I used the search (for #### and for width and for columnwidth), but never got a hit. Hmmm. Jim Cone wrote: 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 "Dave Peterson" wrote in message ... 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. Jim Cone wrote: 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 "Dave Peterson" wrote in message ... 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 -- Dave Peterson |
|
#11
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
autofit problem
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. Jim Cone wrote: 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 "Dave Peterson" wrote in message ... 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. Jim Cone wrote: 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 "Dave Peterson" wrote in message ... 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 -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| autofit row problem | Excel Discussion (Misc queries) | |||
| Row Autofit problem Excel 2003 | Excel Discussion (Misc queries) | |||
| Row Autofit Problem | Excel Discussion (Misc queries) | |||
| Excel WordWrap/AutoFit Problem - the row becomes too tall | Excel Programming | |||
| Column Autofit Problem | Excel Programming | |||
Linear Mode
