View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Maver1ck666 Maver1ck666 is offline
external usenet poster
 
Posts: 34
Default Using VB to find certain lines of data with colour formatting

Hi,

I been provided with a spreadsheet of over 10,000 line of data which I need
to do a mailing for.

The only problem is, some of the lines have been coloured (cell colouring)
which requires a different type of mailing.

Is there a way I could use VB to to sort the data by the cell colour so that
I could cut all the ones which require a different letter?

Thanks in advance for your help.

Maver1ck666