Names of ranges

S

Sarah

Hi all
Does anyone know if it is possible to create a range name that is local to a
worksheet within a workbook? When I try to do this interactively, Excel
seems to enforce unique range names across an entire workbook. However,
sometimes the Insert Name Define dialog box seems to display a right column
that for certain range names displays the related worksheet. I haven't yet
been able to ascertain whether this phenomenon occurs only when I upgrade
old spreadsheets into Excel XP or if there is some magic way I have been
creating these quasi-local range names without realising it.



TIA
Sarah
 
T

Tushar Mehta

In the Insert | Name > Define... dialog box, type the name as 'Sheet1'!
MyName

Note the single quotes surrounding the worksheet name.

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 
S

Sarah

D'oh

Thanks Tushar

Sarah

Tushar Mehta said:
In the Insert | Name > Define... dialog box, type the name as 'Sheet1'!
MyName

Note the single quotes surrounding the worksheet name.

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
Click to expand...
 

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

Issue with local named relative range 2
renaming cell ranges 1
VBA - exporting serial letters to single documents 0
Excel 2010 Table not showing in Access 2010 Import List 0
Pasting a cell into bookmarked table from excel vba 1
Copying Portions of Data 0
Dynamically assign macro 23
Automatically create ranges and then name them 7

Top