Stuart,

I just tried to show you the technique, you have to set something to that
range, such as

Set myRange = ActiveCell.Resize(6,1)

which returns you a range object that you can work with.

I tend to avoid select like the plague if I can, it is slow and usually not
necessary.

--

HTH

RP

"Stuart Sigafoos" wrote in message
...
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!