Did you use book1.xls and book2.xls?

If you did, then you had to save the workbooks before running the code.

If you didn't save, then just use book1 and book2. And each of those workbooks
did have a sheet named sheet1??

I don't know what the "extra end sub" line was.

If you still have trouble, post the code and the names of the workbooks.

Jenno wrote:

Hi Dave

I used book1 and book2 (as in new excel workbooks) to test this macro,
and I just copied and pasted the coding you kindly provided, deleting
the Option Explicit line and extra end sub as generated by the
program.

Jenno

--
Jenno
------------------------------------------------------------------------
Jenno's Profile: http://www.excelforum.com/member.php...o&userid=26236
View this thread: http://www.excelforum.com/showthread...hreadid=397691

--

Dave Peterson