| Home |
| Search |
| Today's Posts |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Common range name for 2 sheets
Whew!
Glad you got it working. David wrote: Dave Peterson wrote Include the sheet name in the name definition: Insert|Name|Define Names in workbook: 'yoursheetnamehere'!SortRange Aha! Stupid me was leaving out this important part!! After reading a reply from Bob Phillips in a 2004 thread, the lightbulb went off. Rechecking here comfirmed my oversight. Could have save lots of time if I'd read your reply more carefully. Many thanks. -- David -- Dave Peterson |
| 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 | |||
| How do I edit a Named Range using macro's | Excel Worksheet Functions | |||
| range of data from different sheets | Charts and Charting in Excel | |||
| calculating excel spreadsheet files for pensions and life insurance (including age calculation sheets) | Excel Worksheet Functions | |||
| How do I multipy a range of cells by a common number? | Excel Worksheet Functions | |||
Threaded Mode
