sort by color

  • Thread starter Thread starter Churley
  • Start date Start date
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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sort by color "NAME?" error 5
Error Installing "ADAPTEC EZCD 4.04" 1
Excel VBA - counting cells by colors and names to it in two different rows. 0
Sorting a spreadsheet by strikethrough? 1
How to filter rows data based on background color of individual cells 1
Excel VBA - Problem with Closing Print Preview 0
Sorting by color of font 4
sort by colors 4

Back
Top