LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default Naming Cells

When I try to name a range of cells, the sheet name is automatically included. Is it possible to exclude the sheet name so that the same cell range can have the same name on every sheet in the same workbook
Turning on the option to include labels in formulas mostly solved the problem but occasionally there are number typos that don't get fixed right away
Grouping sheets and selecting the range work okay as well, but I'm more comfortable with names

tj
 
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
naming cells ranswert Excel Worksheet Functions 7 November 1st 08 08:44 PM
Range naming cells with blank cells through coding Naveen J V Excel Discussion (Misc queries) 1 March 27th 08 01:46 PM
naming cells Mike C Excel Discussion (Misc queries) 3 April 20th 07 12:58 AM
Naming cells... Steve Excel Worksheet Functions 6 January 3rd 06 07:40 PM
Naming cells Watercolor artist Excel Discussion (Misc queries) 9 July 13th 05 01:19 PM


All times are GMT +1. The time now is 12:03 AM.

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

About Us

"It's about Microsoft Excel"