If the one to copy from is open, is there code to prompt and wait for the
destination file to open? Probably not. Thank you Jim.
Annie

"Jim Thomlinson" wrote:

That is a little tricky from the standpoint of which sheet would you like to
copy to. What if there are multiple books open, then which book should it
copy to. The logic is really fuzzy making the code complex.
--
HTH...

Jim Thomlinson


"Annie" wrote:

Is is possible for a macro to copy a range of cells from one file to the same
range in another file? The two files would be open; but the file names may
change. The recorder records absolute ranges correctly, but hard codes the
file names. Thanks for any help.
Annie