Having an array receive its own value

[Isoka]

Hello,

I am trying to have an array receive its own value plus a specific cell value:
myarray(1) = myarray(1) + Cells(2,4)
But I get error "13": Incompatible types (translated from Portuguese)
I have verified that if I make it:
myarray(1) = Cells(2,4)
It works.
The array has been declared as string.
Please help me out figuring out how to do this. Best regards,

 

[mikerickson]

If you are working with strings, use the & operator

myArray(1) = myArray(1) & Cells(2,4).Text

 

[Isoka]

Hi mikerickson, that was quick, thanks! Actually I am working with numbers, up to 100,000. I want to add some value to the array value each time it passes through a loop.

 

[Isoka]

Hello,

I have learned that the array must be declared as Long in order to work with numbers. SOlved!
Thanks.
Best regards,

 

[mikerickson]

If they are decimal numbers (e.g. 12.5 instead of 12) the array should be declared Double. Long is a data type for integers only.

Long won't crash the code, but it will remove the fractional part of the numbers.

 

[Isoka]

Thanks mikerickson! I just might change it to Double then.
Problem solved!
Best regards,