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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Global Range Name Replace 1

Status
Not open for further replies.
sniggih

sniggih

Technical User
Jan 23, 2002
22
0
0
US
I have a rather large spreadsheet set up that has a lot of range names. I would like to globally change the names without having to reset up all the names. Can this be done? Also, will the formulas that are based on those ranges change as well?
 
Sort by date Sort by votes
Status
Not open for further replies.

Similar threads

N1GHTEYES
  • Question
Count range overlap cells
Replies
3
Views
135
N1GHTEYES
N1GHTEYES
N1GHTEYES
  • Question
Count areas within a range 1
Replies
14
Views
554
SkipVought
S
pendle666
  • Question
Microsoft Word - removing index entries with find/replace and wildcards
Replies
4
Views
523
pendle666
pendle666
PSchubert
  • Locked
  • Question
Excel - SUMIFS() works with one range, but doesn't with another nearly identical range 2
Replies
6
Views
124
Andrzejek
Andrzejek
jlr123
  • Locked
  • Question
Replace Link - keep part of formula
Replies
5
Views
66
jlr123
jlr123

Part and Inventory Search

Sponsor

Back
Top