I can't get my macro to recognize names i've given to cells i.e.

If Sheets(I).Names("Quote_Status") = "Closed" Then

it won't recognize Quote_Status as the name of a cell even though there is a
cell on the sheet specified (variable in this case) with that name.