On Jul 2, 11:01*am, wrote:
Duh!

It works fine. *I failed to mention (because I didn't think about it) that
the code was in an addin. *I should have used ActibeWorkbook instead of
ThisWorkbook.

ActiveWorkbook is for the book that is active
ThisWorkbook is the book that contains the code.