Post up the workbook and point out the NameRange that's causing the error and on which worksheet. We'll check it out.