Question reguarding how VBA works...(hidden arrays?)

[anon]

Hello,

I have a question regarding how VBA works. Suppose I want to concatenate two columns of values. Once concatenated, I want to manipulate certain values within the now concatenated column. However, I don't really need to actually see the concatenated values. When programming in VBA, do I have to actually put the concatenated values inside of a worksheet column? Or can VBA store the concatenated values without having to put it into a worksheet? I'd prefer to keep it all in VBA so I don't even have to create a blank worksheet just so VBA can concatenate and then do it's calculations.

In other words, can I create arrays in VBA without actually specifying where in a worksheet it will be located? Or do I actually need to locate it somewhere?

Does this make sense?

Thanks!

[Norie]

The short answer is yes.

Using arrays to manipulate worksheet data in VBA is quite common.