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)

"Chris Gorham" wrote in message
...
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

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.

--
Regards,
Tom Ogilvy



Chris Gorham wrote in message
...
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