Wow neat. It lists only the range names that don't have ref errors. Tried unprotecting sheets. Still not helping. I got procedure in personal macro workbook. That shouldn't make a difference,should it? Dunno, I am at a loss here. Thanks again for your input.