Hi all,
Is there a limit to the size of a variable in VBA? Here is my psuedo
code:
Dim temp
'array has about 2000 items (each item is less than 200 letters)
Loop i=0 To UBound(array)
temp = temp + vbNewLine + array(i)
Next
For some reason it won't append past a hundred or so itterations.
Any idea why this is? Do I need to declare the variable as "large" or
something?
Thanks!
Erik
--
erikcw
------------------------------------------------------------------------
erikcw's Profile:
http://www.excelforum.com/member.php...o&userid=28797
View this thread:
http://www.excelforum.com/showthread...hreadid=489190