Dannottheman
Board Regular
- Joined
- Dec 24, 2020
- Messages
- 55
- Office Version
- 2007
Hello,
I searched and did not find an answer to this here or other sites that would work.
I need a VBA that will resize the column width/wrap the text of all the rows in column A if they exceed "x" amount of characters. (Issue: I am converting the sheet as a PDF and if the text is too long then it appears outside the PDF page or as a separate page). The whole last word/text of the row should move onto the next row (perhaps this is called "orphaning"?. In other words, text should not get split in two, the whole last word should move down to the next sentence and then the rest of the text. If more than one sentence within the same row exceeds "x" characters, they should also wrap following the same rule. For example, if the limit were 10 characters:
Existing:
This is a test message
New (after wrap):
This is a test
message
I searched and did not find an answer to this here or other sites that would work.
I need a VBA that will resize the column width/wrap the text of all the rows in column A if they exceed "x" amount of characters. (Issue: I am converting the sheet as a PDF and if the text is too long then it appears outside the PDF page or as a separate page). The whole last word/text of the row should move onto the next row (perhaps this is called "orphaning"?. In other words, text should not get split in two, the whole last word should move down to the next sentence and then the rest of the text. If more than one sentence within the same row exceeds "x" characters, they should also wrap following the same rule. For example, if the limit were 10 characters:
Existing:
This is a test message
New (after wrap):
This is a test
message