Please, help me to make automatic autofit row height on merge cells changed.
this thread following on from http://www.excelforum.com/showthread...t=#post4446560 autofit for not merged cells.
on the same row I have some data that must be autofit, how to prevent the little data change row size of the much data? or two code work will alternate the amount of data.
Maybe :
Please Login or Register to view this content.
1. I care dog
2. I am a loop maniac
3. Forum rules link : Click here
3.33. Don't forget to mark the thread as solved, this is important
@karedog
your code just works for autofit without merged cells.
Really ?
Try these steps :
- Press del (delete) cell A5
- Autofit entire row 5 manually
- Run the macro
Thanks your code works well. But it works manually. Would you like to modify it to run automatically when there is a change, like this one http://www.excelforum.com/showthread...t=#post4446560
Put this code in Sheet1 module :
Please Login or Register to view this content.
@karedog
Thanks a lot, your code works very well. And it will make me work more fun.
But I have some Sheets, why the size of the other rows are same as Sheet1? So, my data on the others Sheets that have many words can't be shown.
edited
sorry, it is influenced by the size of the zoom and the problem is solved
Last edited by putritersenyum; 08-05-2016 at 05:41 AM.
You are welcome, thanks for marking the thread as solved and for the rep.points.
Regards
@karedog
would you like to make your code run automatically on the value of cell is changed without press enter button from the cells (auto trigger)?
You mean the row autofit is triggered when you are typing on the cell ?
This is not possible, because no macro can be run while you are editing a cell (edit mode), this is designed this way by Microsoft.
What you can do is, before you edit/type something on cell, change the row height big enough as you predicted the text will be fit, then do the editing/typing. As soon as you finish editing/typing (by pressing enter or click on other cell), the macro will immediately do the autofit for you.
@karedog
Sorry, I mean the row autofit value changed by another cell.
For the explanation, please try this file:
First, you need to delete all the code in ThisWorkbook module (Sub Workbook_SheetChange())
Then change the code on Sheet1 module to this :
Please Login or Register to view this content.
@karedog
Thanks so much, that really works great.
You are welcome, glad to help.
Regards
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks