Hello!


I have a table in an excel-sheet showing my contacts.
I use a VBA-loop to add up the emails of my contacts and store them in
a string variable (separated by an ';' of every contact).

Problem is, it adds up to about 4000 characters total.

The cell that I have chosen to display the complete variable shows
only the first 1024 characters of the string value.

Is there a way using VBA I can show the full 4000 character string?


Best regards
NorTor