On Thu, 20 Dec 2007 11:18:57 -0000, "Bob Phillips"
wrote:

No it is the book name

Workbooks("my other book.xls")

instead of activeWorkbook.

Pass it as a parameter like the rest.

Thanks Bob,

That worked a treat :-)

Cheers - Kirk