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