Names of ranges

  • Thread starter Thread starter Sarah
  • Start date Start date
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
 
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
 
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...
 
Back
Top