Terry,

You can, but isn't TestSrc and TestDest worksheet names in this case?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"terry b" wrote in message
oups.com...
Hey, Jim,
Thanks for simplifying things! Your suggestion does what I was trying
to do in line 6, but evidently when I included the 'Sheets' & 'Range'
properties I was clouding things up for no good reason.... One other
question: When referring to a variable such as TestSrc, can you use
"Range(TestSrc)"? Whenever I try to do that, I get this: "Run-time
error '1004': Method 'Range' of object '_Global' failed"....Can't you
use a variable name as an argument in 'Range'?
Again, thanks much for the help.
terry b.