Code to delete entire row deletes entire named range instead
See the attached code
Worksheet, Master, is created by copying Sheet1 to it. I have a named range that I search and when I find the word no in it I want to delete that entire row. However when I attempt the delete all the rows in the named range are deleted instead.