Hi Ron:

Thanks for the uber-fast reply! And thanks for the link. I'll try
switching things around to opening up the external files manually and see if
that helps.

Do you have any idea, though, why the blank cells were replaces with
zeroes?

Thanks again.

Jon

"Ron de Bruin" wrote in message
...
Opening the workbook with code give you much more control
and most of the time fast.

If you need help with the code post back

This page give you a start
http://www.rondebruin.nl/copy3.htm

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"JonWestcot" wrote in message
...
Hi Roy, Ron, et al.:

Have you tried using the code and received an error? If so what error?
Have you used Ron's example codes whilst changing the relevant
variables?

Yes, I've tried the code. The error I get indicates that the Range
fails on the _Global object.

However, I believe I figured out part of my problem. I was
specifying a
named range from the source file when I really needed to specify an
actual
range. Once I did that, the aforementioned error went away.

But, now I have two more problems! :(

First, I am trying to copy a range of 8 rows, 1 column wide. The
values, in order, a

A, B, C, , , , , X

However, when they paste, a 0 (zero) replaces the blanks. And, try
as I
might, I cannot get blanks to be pasted in.

Second, I have two situations where I need to copy the entire
contents
of one closed worksheet into a sheet in my open workbook. Is there a
way to
specify a range generically that will let me do this?

Thanks!

Jon