Hi Scott,

Have a look at this link.
http://xldynamic.com/source/xld.Colo...r.html#sorting

HTH
Martin


"Scott" wrote in message
...
How to select coloured cells only from a block of cells containing
coloured
and non-coloured cells? It may be assumed that the coloured cells are of a
single colour.