Short string limitations?

Hi all

I've a string, in a loop, which is added to at each iteration. After about 500 or so characters are added, no more may be. The concaternation command is ignored. I've not managed in any way to increase the number of characters in that string. The string has no obvious limitations on it, but I'm sure (and the MSDN says) that by default a string can be some 16 billion chars long.

Any idea what's going on? Others around here claim to have had the problem also, but no solutions.

I'm using VBA on Excel 2003.

Can you post the code. I don't seem to have any problems with string lengths.

Thanks

Sure. The code itself is long and winding, so I've stripped it down to only the lines relevant to lrvList, the string which is being limited.

Please Login or Register  to view this content.

Hmm, I think I've got it. Annoying!

It looks like the string isn't limited at all, but rather all the methods I've tried outputting it are. Although cells, messageboxes and the debug watch all seemingly truncated the string, a right(lrvlist, 6) gives a different value to the read ones. Sound like a resonable explaination?

If so, what options are there to easily output a long string?