Autofit row height
 

I am trying to make the height of a row change automatically. I know that
formatrowautofit should accomplish that, but for some reason it is not
working. I have formatted the cells I need to word wrap. Several of the
cells in the row are formatted for numbers or date entry. What am I doing
wrong?

I have used the autofit function before, but it never seems to autofit the
row height consistently. Sometimes it will work and other times it won't.

I hope someone can help me. Thanks.

Autofit row height
 

I don't know if your problem has the same cause as mine, but I had a
worksheet with cells which autosized much wider (column) or taller (row) than
necessary. The problem turned out to be the font, which was Courier. When I
changed the font to Arial, autosizing worked as expected.

Hope this helps,

Hutch

"Odie" wrote:

I am trying to make the height of a row change automatically. I know that
formatrowautofit should accomplish that, but for some reason it is not
working. I have formatted the cells I need to word wrap. Several of the
cells in the row are formatted for numbers or date entry. What am I doing
wrong?

I have used the autofit function before, but it never seems to autofit the
row height consistently. Sometimes it will work and other times it won't.

I hope someone can help me. Thanks.

Autofit row height
 

Any merged cells involved?

If so, remove them or you will be forced to use Event code to autofit rows.

For the code, post back.


Gord Dibben MS Excel MVP


On Thu, 10 Apr 2008 12:34:00 -0700, Odie wrote:

I am trying to make the height of a row change automatically. I know that
formatrowautofit should accomplish that, but for some reason it is not
working. I have formatted the cells I need to word wrap. Several of the
cells in the row are formatted for numbers or date entry. What am I doing
wrong?

I have used the autofit function before, but it never seems to autofit the
row height consistently. Sometimes it will work and other times it won't.

I hope someone can help me. Thanks.

Autofit row height
 

Thanks for the response. Yes, merged cells are involved. I did not realize
this would be an issue. I often use merged cells, so I would appreciate
knowing about event code.

Thanks.

"Gord Dibben" wrote:

Any merged cells involved?

If so, remove them or you will be forced to use Event code to autofit rows.

For the code, post back.


Gord Dibben MS Excel MVP


On Thu, 10 Apr 2008 12:34:00 -0700, Odie wrote:

I am trying to make the height of a row change automatically. I know that
formatrowautofit should accomplish that, but for some reason it is not
working. I have formatted the cells I need to word wrap. Several of the
cells in the row are formatted for numbers or date entry. What am I doing
wrong?

I have used the autofit function before, but it never seems to autofit the
row height consistently. Sometimes it will work and other times it won't.

I hope someone can help me. Thanks.

Autofit row height
 

Odie

Check out this google search thread from June 2007

http://tinyurl.com/5pua8z

Note: an "Odie" has taken part............coincidence?


Gord


On Sat, 12 Apr 2008 07:33:00 -0700, Odie wrote:

Thanks for the response. Yes, merged cells are involved. I did not realize
this would be an issue. I often use merged cells, so I would appreciate
knowing about event code.

Thanks.

"Gord Dibben" wrote:

Any merged cells involved?

If so, remove them or you will be forced to use Event code to autofit rows.

For the code, post back.


Gord Dibben MS Excel MVP


On Thu, 10 Apr 2008 12:34:00 -0700, Odie wrote:

I am trying to make the height of a row change automatically. I know that
formatrowautofit should accomplish that, but for some reason it is not
working. I have formatted the cells I need to word wrap. Several of the
cells in the row are formatted for numbers or date entry. What am I doing
wrong?

I have used the autofit function before, but it never seems to autofit the
row height consistently. Sometimes it will work and other times it won't.

I hope someone can help me. Thanks.

Autofit row height
 

Thank you, your response has been helpful. And yes, Odie is a quite a
coincidence. It was not me.

"Gord Dibben" wrote:

Odie

Check out this google search thread from June 2007

http://tinyurl.com/5pua8z

Note: an "Odie" has taken part............coincidence?


Gord


On Sat, 12 Apr 2008 07:33:00 -0700, Odie wrote:

Thanks for the response. Yes, merged cells are involved. I did not realize
this would be an issue. I often use merged cells, so I would appreciate
knowing about event code.

Thanks.

"Gord Dibben" wrote:

Any merged cells involved?

If so, remove them or you will be forced to use Event code to autofit rows.

For the code, post back.


Gord Dibben MS Excel MVP


On Thu, 10 Apr 2008 12:34:00 -0700, Odie wrote:

I am trying to make the height of a row change automatically. I know that
formatrowautofit should accomplish that, but for some reason it is not
working. I have formatted the cells I need to word wrap. Several of the
cells in the row are formatted for numbers or date entry. What am I doing
wrong?

I have used the autofit function before, but it never seems to autofit the
row height consistently. Sometimes it will work and other times it won't.

I hope someone can help me. Thanks.

Autofit row height
 

Blow away those insidious merged cells and your Excel worksheet life will be
much easier.

I know they have their uses for presentation but they may be close to the
greatest problem-causer we see.

Thanks for the feedback.


Gord

On Sat, 12 Apr 2008 09:59:03 -0700, Odie wrote:

Thank you, your response has been helpful. And yes, Odie is a quite a
coincidence. It was not me.

"Gord Dibben" wrote:

Odie

Check out this google search thread from June 2007

http://tinyurl.com/5pua8z

Note: an "Odie" has taken part............coincidence?


Gord


On Sat, 12 Apr 2008 07:33:00 -0700, Odie wrote:

Thanks for the response. Yes, merged cells are involved. I did not realize
this would be an issue. I often use merged cells, so I would appreciate
knowing about event code.

Thanks.

"Gord Dibben" wrote:

Any merged cells involved?

If so, remove them or you will be forced to use Event code to autofit rows.

For the code, post back.


Gord Dibben MS Excel MVP


On Thu, 10 Apr 2008 12:34:00 -0700, Odie wrote:

I am trying to make the height of a row change automatically. I know that
formatrowautofit should accomplish that, but for some reason it is not
working. I have formatted the cells I need to word wrap. Several of the
cells in the row are formatted for numbers or date entry. What am I doing
wrong?

I have used the autofit function before, but it never seems to autofit the
row height consistently. Sometimes it will work and other times it won't.

I hope someone can help me. Thanks.

Autofit row height
 

Thanks again. That's what I decided to do. I don't feel comfortable dealing
with code, so I redesigned the worksheet to eliminate the merged cells.
However, this answered my question about why autofit only works sometimes.
That was helpful.

Thanks.

"Gord Dibben" wrote:

Blow away those insidious merged cells and your Excel worksheet life will be
much easier.

I know they have their uses for presentation but they may be close to the
greatest problem-causer we see.

Thanks for the feedback.


Gord

On Sat, 12 Apr 2008 09:59:03 -0700, Odie wrote:

Thank you, your response has been helpful. And yes, Odie is a quite a
coincidence. It was not me.

"Gord Dibben" wrote:

Odie

Check out this google search thread from June 2007

http://tinyurl.com/5pua8z

Note: an "Odie" has taken part............coincidence?


Gord


On Sat, 12 Apr 2008 07:33:00 -0700, Odie wrote:

Thanks for the response. Yes, merged cells are involved. I did not realize
this would be an issue. I often use merged cells, so I would appreciate
knowing about event code.

Thanks.

"Gord Dibben" wrote:

Any merged cells involved?

If so, remove them or you will be forced to use Event code to autofit rows.

For the code, post back.


Gord Dibben MS Excel MVP


On Thu, 10 Apr 2008 12:34:00 -0700, Odie wrote:

I am trying to make the height of a row change automatically. I know that
formatrowautofit should accomplish that, but for some reason it is not
working. I have formatted the cells I need to word wrap. Several of the
cells in the row are formatted for numbers or date entry. What am I doing
wrong?

I have used the autofit function before, but it never seems to autofit the
row height consistently. Sometimes it will work and other times it won't.

I hope someone can help me. Thanks.