Hi Richard

I go the eror using yor uploaded files. however, when I converted the files to 2007 format (*.xlsm and *.xlsx) the code ran without errors.

let me know if you want the converted books.

__________________
Hope that helps.

RoyUK
--------
If you are pleased with a member's answer then use the Scales icon to rate it

For Excel consulting, free examples and tutorials visit my site
Check out the free Excel Toolbar

New members please read & follow the Forum Rules

Remember to mark your questions Solved and rate the answer(s)

Where to copy the code to

Code Tags: Make your code easier for us to read