sort by color

C

Churley

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
 
G

Gord Dibben

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
 
Top