autosizing

[windaroo]

I have used 2 macros in order to automatically resize the row height in merged cells when using wordwrap. The first code enables the resizing, the second to automatically run the macro when the sheet changes. The problem I have having is that the resizing only occurs if I re-click on the cell after I have entered the data. Can someone tell me what I am doing wrong? Here is the code I am using:

To resize rows (located in the Module)

Please Login or Register  to view this content.

To automatically run the macro when a change is made within the sheet (located in the worksheet Object)

Please Login or Register  to view this content.

Thanks

Tania

[romperstomper]

Hi and welcome to the forum.

Please can you enclose all code in code tags when posting in future? (I have added them for you on this occasion)

Your problem is that your code uses the selectionchange event which occurs when you select another cell, not when you alter a cell. Hence the active cell to which your code refers is not the one you just changed. You need to use the Change event instead.

[pike]

Hi windaroo,
The first trick is dont merge cells but, if you have then
In the same row where the cells are merged, and a column out of site, size a cell to the same width as the meged cells and enter formula to = the merged cell . Format the cell for text wrap. now the cells will auto resize to match the merged cells.

[windaroo]

Okay, so I know my resizing code works, but I still can't get my macro to auto run. I have tried the Worksheet_Change(ByVal Target As Range) but now my macro won't autorun at all.

The sheet is being used to collect annual performance assessment data, so it will be filled out my many other users. I simply want the macro to run, when users enter commentary. Unfortunately I can't get away with not having merged cells. I also tried adding in another column but this didn't work either.

And apologies for not following the correct posting format, thanks for letting me know. I will be sure use the tags in the future.

[romperstomper]

Just make sure you haven't ended up with events disabled. In the VBE, press Ctrl+G to open the Immediate Window, type:

Please Login or Register  to view this content.

in the window and press enter. Then see if the code runs.

[windaroo]

Just make sure you haven't ended up with events disabled. In the VBE, press Ctrl+G to open the Immediate Window, type:

Please Login or Register  to view this content.

in the window and press enter. Then see if the code runs.

Thanks for your help, nothing happened though. I have tried a number of different ways to code it and still can't get it work on the Worksheet_Change event.

Please keep helping me!

[windaroo]

Thanks for your help. I managed to find another set of code that has solved all my problems. It is probably not as clean as I would like but it works.