Wrap text(with more than 1024 characters) in Merged Cells in Excel Sheet using VBScript/VBA

Category:
Office/VBA
Type:
Applications
Difficulty:
Intermediate
Author:
Anonymous

Version 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:

Code: