ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Using VB to find certain lines of data with colour formatting (https://www.excelbanter.com/excel-programming/390146-using-vbulletin-find-certain-lines-data-colour-formatting.html)

Maver1ck666

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

Ben McBen

Using VB to find certain lines of data with colour formatting
 
Can I recommend:

http://www.ozgrid.com/VBA/Sort.htm


All times are GMT +1. The time now is 08:10 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com