You're probably not going to get much help if you don't say why the
previous suggestions won't work for you. Why would anyone want to put
more time into playing "bring me a rock"?

The macro I suggested will easily concatenate 2000 rows in less than a
second.

The number of In article
,
moglione1
wrote:

Still no further with this. Forgot to mention there is about 2000
rows of data.