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

Signature
thank you so much for your help
Charles Williams - 19 Sep 2007 14:32 GMT
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
> Hi there,
>
[quoted text clipped - 4 lines]
>
> Clara