It seems that the "characters object" in Excel has a limitation of 256
characters. The object allows you to access, insert or delete
characters from a cell without affecting the rich text formatting. It
however only works of the cell contains 256 or less characters
otherwise it does nothing and does not give an error message.
Is there another object that can access all the characters in a cell
while still preserving the rich text formatting? Obviously there is
such an object (otherwise Excel itself would not be able to function
correctly) but how do one access it?