Increasing the Speed of Concatenation

Hello All,

First of all, this is my first post so if there is anything I'm doing wrong, do let me know. I had a long look through the forums and found nothing specific on the topic of concatenation speed.

Some background:
I import web data into an area roughly 20 columns wide and 2000 rows tall. In order for this data to be analyzed, each column (B to T) must have its value appended to the value of A. This of course is repeated for the 2000 rows.

Conceptually, I want the value of A1 to equal A1 & B1 & C1 ... & T1. A2 should equal A2 & B2 & C2 ... & T2. And so on. The relevant VB Code that I have been using to do this is:

Please Login or Register  to view this content.

The issue is that this code takes about 20 seconds to run. (This occurs about 500 times in my project!) Are there any faster methods for concatenating the contents of multiple cells?

Thanks in advance!

This seems faster than 20 seconds.

Please Login or Register  to view this content.

This should do it in less than a second, no looping at all:

Please Login or Register  to view this content.

The error you describe could be to do with the data, it's unlikely to be with the declarations.