Bob,

Thanks for the quick responce.

The ActiveCell.Resize did not work; VB showed a 'compile error
=expected' and I could not figure out what I was missing.

But, using VB Help, I looked up the Resize function, and found that
"Selection.Resize(rangeToCopy, 1).Select" would in fact do exactly what
I wanted (and works!)

Again, thanks for pointing me in the right direction!

Stuart



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!