Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Range Name
How can I create a range name that is only used for a particular worksheet,
rather than the whole workbook? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Range Name
You can create a local or sheet level name by including the sheet name in the
range name. Insert|name|define (xl2003 menus) Names in Workbook 'Sheet name goes here'!MyNameHere (for example) You could also select the range and type the complete name in the name box (to the left of the formula bar). (Make sure you hit enter when you're done typing.) Té wrote: How can I create a range name that is only used for a particular worksheet, rather than the whole workbook? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cond. Format Data Bars of range based on values of another range | Excel Worksheet Functions | |||
Excel Addin:Setting the range to the Excel.Range object range prop | Excel Worksheet Functions | |||
Selecting range in list of range names depending on a cell informa | Excel Discussion (Misc queries) | |||
formula to sort a range so that it matches the exact rows of a column that is outside that range? | Excel Discussion (Misc queries) | |||
How to count dates within a certain range in a column with mutiple date range entries | Excel Worksheet Functions |