How to write a long text value to an Excel Cell in a VBA subroutine
Posted on 2013-08-28
I have a feeling this is pretty simple.
I have a VBA subroutine that assigns all sorts of small numbers adequately.
However I have some long code numbers that defeat the process. For example I have a string as follows:
If I use the following assignment
ActiveCell.Value = array(i)
it results in this:
My array(i) is a string array element. In the debugger it looks correct but when I view the spreadsheet the final character is screwed up.