You can use Name Manager (developed by me and JK Pieterse) to filter out
duplicate global/local names, and to convert Global--Local--Global etc
http://www.decisionmodels.com/downloads.htm

Charles
______________________
Decision Models
FastExcel 2.3 now available
Name Manager 4.0 now available
www.DecisionModels.com

"clara" wrote in message
...
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