Quote Originally Posted by Norie View Post
Try changing Cells to Source.Parent.Cells.

Source.Parent will return the worksheet Source is on.
Ninja'd.
Thanks, I'll try it.