The macro is designed to be run with both files open. As is obvious from the code I posted, the doesn't make any attempt to open either file. After all, you haven't provided any indication of whether either file is stored in relation to the other. The macro can be run from any open Excel file.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
|