Keith

I hope you got your improvement in speed.

A little experimentation seems to indicate that the maximum string
length that can be copied by this method is about 900 characters in
Excel 2003.

Helpfully, Microsoft have arranged different limits in different
versions of Excel!

Best wishes

Peter