Automatic Row Height

[bomalley]

Hi there,

Does anyone know how to make row height automatic after changing values in cells.
I have data in a cell that automatically word wraps, and increases the height of the row. However if that data changes, the row height stays the same, rather than shrinking (if the length of the data is less).

 

[Juan Pablo González]

Just to give some developer tips... there's no need to use Application.Run UNLESS the Sub is in another Workbook. If it's in the same you can just use

Call MyMacro

or even better

MyMacro

 

[NateO]

Thanks Juan!

Incidentally, one of my favorite songs, by Rush, ("Passage to Bangkok") refers to Bogotá.

Cheers,

Nate
This message was edited by NateO on 2002-02-19 21:11

 

[bomalley]

Hello again Nate,

Not sure ik I was clear in my last message. I wanted to do the same thing as the first macro, but I wanted it to run on a change to a drop down menu control I have on that sheet, rather than selection change.

 

[bomalley]

Don't worry Nat, I have sorted it.

Thanks heaps for your help.

Cheers,
Brandon