Download the modcolorfunctions.zip file from

http://www.cpearson.com/excel/SortByColor.aspx

Unzip the *.bas file and import as a module to any workbook.

All the functions needed are in that module.

Not an add-in.............nothing to install.


Gord Dibben MS Excel MVP

On Wed, 24 Mar 2010 13:37:42 GMT, "BNT1 via OfficeKB.com" <u19326@uwe
wrote:

Hi

Is it possible to sort by colour, with using an Add-in, as I am at work and
will not permit any install

tried the links to cpearson etc, but i see they were add-ins

glad to use any VBA, if anyone has it, of point me in the direction?
using Excel 2003

thanks