Wrap text(with more than 1024 characters) in Merged Cells in Excel Sheet using VBScript/VBA
Category:
Office/VBAType:
ApplicationsDifficulty:
IntermediateAuthor:
AnonymousVersion Compatibility:
More information:
I was facing problem to wrap text in Excel sheet merged cells, when text is having more than 1024 charatcers. I have added 'Carriage Return' characters after each 100 characters, once first 1024 characters are passed.
Instructions: Copy the declarations and code below and paste directly into your VB project.
Declarations: