| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sorting data with Named Ranges
Your assuming the ranges/cells move. The formatting and value move, but I
am not sure you can say the cell moves. If you have a formula outside the sorted range refering to a cell in the sorted range, the formula doesn't change as a result of the sort. -- Regards, Tom Ogilvy "Gap" wrote in message oups.com... Thanks Tom, I was just wondering if this is the right behavior in Excel. Names are supposed to be attached to or propertyh of the Ranges both technically speaking and in business sense. Regards Amitabh |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Named Ranges Not Working in Data Validation | Excel Worksheet Functions | |||
| How do I use Named Ranges as Data Validation Lists? | Excel Worksheet Functions | |||
| Named Ranges in external Data Sources | Excel Programming | |||
| Excel2000: Custom data validation and named ranges | Excel Discussion (Misc queries) | |||
| Sorting lists of Named Ranges | Excel Programming | |||
Threaded Mode
