Hey all,
I'm not sure if this is at all possible, but I figuredif it is someone here would be able to help.
I'm trying to find a vba code that will automatically adjust the height of certain merged cells on a single row whenever the text becomes too long and gets cut off. I found a code that automatically adjusts all my merged cells in one go, but it is a one time thing and doesn't take effect whenever the cell is modified, so I scrapped it.
This is a worksheet that is constantly being worked on so sometimes there will be no text in the cells, in which case they can stay at 35 height (the default I set them as), but other times there may be lots of text and so I would need the cell to adjust automatically whenever the text passes the default 35 height. As of now I am adjusting the height manually each time, whenever needed, but if there is a way to have this done automatically that would be fantastic.
The range of cells that I want to be affected by this are B24 to E24, B30 to E30, B32 to E32, and B38 to E38.
Also it should be noted that I already have another vba code in place for this worksheet, to create a pdf file from the sheet and attach it in an outlook email. I have 2 modules for this, so I'm wondering where this new code will need to be placed?
Thanks in advance to anyone who is able to help me out here!
I'm not sure if this is at all possible, but I figuredif it is someone here would be able to help.
I'm trying to find a vba code that will automatically adjust the height of certain merged cells on a single row whenever the text becomes too long and gets cut off. I found a code that automatically adjusts all my merged cells in one go, but it is a one time thing and doesn't take effect whenever the cell is modified, so I scrapped it.
This is a worksheet that is constantly being worked on so sometimes there will be no text in the cells, in which case they can stay at 35 height (the default I set them as), but other times there may be lots of text and so I would need the cell to adjust automatically whenever the text passes the default 35 height. As of now I am adjusting the height manually each time, whenever needed, but if there is a way to have this done automatically that would be fantastic.
The range of cells that I want to be affected by this are B24 to E24, B30 to E30, B32 to E32, and B38 to E38.
Also it should be noted that I already have another vba code in place for this worksheet, to create a pdf file from the sheet and attach it in an outlook email. I have 2 modules for this, so I'm wondering where this new code will need to be placed?
Thanks in advance to anyone who is able to help me out here!
Last edited:
