Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 252
Default workbook level name vs worksheet level name

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
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 968
Default workbook level name vs worksheet level name

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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Question re Workbook level declarations VanS[_2_] Excel Programming 2 March 11th 06 09:12 PM
Using macro to convert single level BOM to Multi Level BOM andrew_chong Excel Programming 0 February 7th 06 08:57 PM
Workbook level recalculation Lavneet Singh Excel Programming 3 November 21st 05 05:52 PM
Global or Workbook level variables. DaveO Excel Programming 2 October 20th 05 09:31 AM
Why, when I create workbook-level name does it jump it to Sheet-level ? Charles Jordan Excel Programming 1 November 5th 03 08:43 PM


All times are GMT +1. The time now is 01:14 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"