Range Names associated with Sheet Name
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 |
Range Names associated with Sheet Name
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 |
Range Names associated with Sheet Name
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 |
All times are GMT +1. The time now is 04:32 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com