| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
sort by color
I have tried to sort by color using a VBA. It was successful on one
spreadsheet I am working on, but not on another. I keep getting the error message "NAME?", and I don't know why. Any help would be appreciated. Thank you |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
sort by color
The NAME error means that Excel cannot find the function to sort by color.
It must be present in each workbook or point the function to the workbook that contains the code. =workbook1.xls!sortbycolor(A1,false) or similar in workbook2 Gord Dibben MS Excel MVP On Fri, 15 Feb 2008 08:22:01 -0800, Churley wrote: I have tried to sort by color using a VBA. It was successful on one spreadsheet I am working on, but not on another. I keep getting the error message "NAME?", and I don't know why. Any help would be appreciated. Thank you |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sort by color | Excel Discussion (Misc queries) | |||
| Sort using color | Excel Discussion (Misc queries) | |||
| How do I sort my data by color? (color applied to rows) | Excel Worksheet Functions | |||
| Sort or sub-total by Fill color or font color | Excel Discussion (Misc queries) | |||
| Excel sort by Fill Color by custom list sort | Excel Discussion (Misc queries) | |||
Hybrid Mode
