Hi Jim,
Thank you. I have Dave's code I can work with. Thank you much.
Annie

"Jim Thomlinson" wrote:

So long as you have a consistent destination workbook then you are good to
go. I can give you code to copy the selected range to an identical range on a
different sheet on that workbook. Let me know if that is what you want.
--
HTH...

Jim Thomlinson


"Annie" wrote:

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