| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Naming a range
Hi all, Is it possible to automatically incorporate the name of the worksheet in the name of a range, eg I want to name cells A1 to A10 of a worksheet called DEPT1 "DEPT1dates". I shall then create additional copies of this worksheet that will be named DEPT2, DEPT3 etc, so that the range of cells A1 to A10 of worksheet DEPT2 is called "DEPT2dates". Thanks in advance for trying to help. Bob -- bob777 ------------------------------------------------------------------------ bob777's Profile: http://www.excelforum.com/member.php...o&userid=28504 View this thread: http://www.excelforum.com/showthread...hreadid=507198 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
| Help with using range names in sum function | Excel Worksheet Functions | |||
| Array to named range conversion... | Excel Discussion (Misc queries) | |||
| How to Select a relative range with Using "Find" and Offset() | Excel Discussion (Misc queries) | |||
| Counting empty cells within a range of cells | New Users to Excel | |||
Threaded Mode
