Hi there,

By accident, there are two set of names in my workbook, workbook level and
worksheet level( existing in some worksheets) and the two set are same. how
can just change the worksheet level names into workbook level names ?

Clara
--
thank you so much for your help