ExcelBanter - sort by color

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - sort by color (https://www.excelbanter.com/excel-discussion-misc-queries/176838-sort-color.html)

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

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