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