Range Names associated with Sheet Name

  • Thread starter Thread starter Chris Gorham
  • Start date Start date
C

Chris Gorham

Hi,

Using the Insert / Name / Define drop down to create a
range name within Excel - I know its possible for the
range name to automatically be associated with the sheet
name - it appears to the right of the range name in
the "define" UserForm.

There's a trick with a key combination that you perform as
you create the name....can someone tell me what it is..

Thks...Chris
 
Chris,

Don't know about a hotkey, but to define it as a local name, just precede
the sheet name before the range name, for example

Sheet1!myRange

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Hold down the alt key while you do ind in succession.

Other than that, you would have to me more explicit about what you mean by
trick.
 
Back
Top