Hi all,

Why does Text Wrap produce two results when a cell holds long text string:
sometime a cell is expended vertically and sometime a cell height keep same.
I am using the 2000 version


Clara

--
thank you so much for your help

Wrap Text and FormatRowsAutofit should do what you want.

If a row has been manually set to a height, it will not expand untill you have
reset to Autofit.

UNLESS you have merged cells, in which case Autofit won't work and rows have to
manually adjusted or adjusted by sheet event code.

See google search thread for code by Greg Wilson

http://groups.google.com/group/micro...1c160cbeb27874


Gord Dibben MS Excel MVP

On Thu, 5 Jun 2008 06:23:02 -0700, clara
wrote:

Hi all,

Why does Text Wrap produce two results when a cell holds long text string:
sometime a cell is expended vertically and sometime a cell height keep same.
I am using the 2000 version


Clara

Hi Gord,

Thank you very much for your help! I often use the microsoft's news group,
but how can I use the google search thread.?

Clara
--
thank you so much for your help


"Gord Dibben" wrote:

Wrap Text and FormatRowsAutofit should do what you want.

If a row has been manually set to a height, it will not expand untill you have
reset to Autofit.

UNLESS you have merged cells, in which case Autofit won't work and rows have to
manually adjusted or adjusted by sheet event code.

See google search thread for code by Greg Wilson

http://groups.google.com/group/micro...1c160cbeb27874


Gord Dibben MS Excel MVP

On Thu, 5 Jun 2008 06:23:02 -0700, clara
wrote:

Hi all,

Why does Text Wrap produce two results when a cell holds long text string:
sometime a cell is expended vertically and sometime a cell height keep same.
I am using the 2000 version


Clara

Best is to use Ron de Bruin's google search add-in.

http://www.rondebruin.nl/Google.htm

To go to google search directly use this URL

http://tinyurl.com/6pksz3

To go to Greg's message just double-click the URL I posted earlier.


Gord

On Fri, 6 Jun 2008 06:20:03 -0700, clara
wrote:

Hi Gord,

Thank you very much for your help! I often use the microsoft's news group,
but how can I use the google search thread.?

Clara

Hi Gord,

AutoFit seems only have one state, I can not change it from the meun. How
can change it ?

Clara
--
thank you so much for your help


"Gord Dibben" wrote:

Wrap Text and FormatRowsAutofit should do what you want.

If a row has been manually set to a height, it will not expand untill you have
reset to Autofit.

UNLESS you have merged cells, in which case Autofit won't work and rows have to
manually adjusted or adjusted by sheet event code.

See google search thread for code by Greg Wilson

http://groups.google.com/group/micro...1c160cbeb27874


Gord Dibben MS Excel MVP

On Thu, 5 Jun 2008 06:23:02 -0700, clara
wrote:

Hi all,

Why does Text Wrap produce two results when a cell holds long text string:
sometime a cell is expended vertically and sometime a cell height keep same.
I am using the 2000 version


Clara

Don't understand the question.

FormatRowAutofit can be off or on.


Gord

On Fri, 6 Jun 2008 06:41:03 -0700, clara
wrote:

Hi Gord,

AutoFit seems only have one state, I can not change it from the meun. How
can change it ?

Clara