Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

named ranges

Status
Not open for further replies.
Guest_imported

Guest_imported

New member
Jan 1, 1970
0
Hi there,

I'm sure most of you know how to name ranges in excel, so do I, but I have this spreadsheet with named currencies and the only problem is that these names only can be used on the same sheet (except if including the sheet name). Looking in the define name box these names have the sheet name written next to them.

My question now is, how do I make my definitions "global"?
 
Sort by date Sort by votes
You can't, Frank. If you can tell me WHY you need named ranges, I can probably tell you how to best get around it.
techsupportgirl@home.com
Brainbench MVP for Microsoft Word
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

EFFEY
  • Locked
  • Question
I have three columns in excel named 1
Replies
5
Views
203
EFFEY
EFFEY
kjv1611
  • Locked
  • Question
Named Range that has Gaps (or at least a gap) - Not working for INDEX and MATCH functions 2
Replies
5
Views
176
kjv1611
kjv1611
NIWANut
  • Locked
  • Question
Interesting use of Named cells 2
Replies
3
Views
44
SkipVought
S
ksnpc
  • Locked
  • Question
conditional formatting formula with date ranges 5
Replies
10
Views
57
ksnpc
ksnpc
Adgat
  • Locked
  • Question
Allow users to edit ranges when protecting worksheet 1
Replies
3
Views
52
James Wallace
James Wallace

Part and Inventory Search

Sponsor

Back
Top