How do i use the same name multiple times in repeating worksheets

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have multiple sheets doing the same calculation. Initially one was set up
and copied mutiple times. This created multiple range names with the same
name but within a sheet.

I now want to create an extra name within each of the 10 sheets but if i use
the same name it simply updates every sheet not each individual sheet.
 
When you create the name, precede it with the sheetname, such as

Sheet1!myName

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Summary from multiple sheets 1
copy worksheet and automatically name 4
Worksheet name variables 3
Need to merge worksheets - Excel 2003 0
using the Excel generic worksheet names instead of user-given names in code 5
using named range in VBA 20
Auto Naming Worksheets 4
Code to format cells on several worksheets 2

Back
Top