Range Names associated with Sheet Name

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
 
B

Bob Phillips

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)
 
T

Tom Ogilvy

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.
 
Top