thanks for the reply.

I receive Error 1004 "Application-defined or Object-defined error" on line "If nm.RefersToRange.Parent.name = ActiveSheet.name Then"