Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
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
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 56
Default Using VB to find certain lines of data with colour formatting

Can I recommend:

http://www.ozgrid.com/VBA/Sort.htm
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formatting Data in cell in colour [email protected] Excel Discussion (Misc queries) 3 January 28th 08 03:28 PM
Colour formatting using command buttons and comparing data. Luke Excel Discussion (Misc queries) 4 January 19th 07 08:19 PM
How do I use conditional formatting to colour rows of data? Simon Excel Worksheet Functions 2 October 6th 06 04:05 PM
How Can I Read Formatting Data (ie Background Colour) iMartyn Excel Discussion (Misc queries) 2 December 8th 05 10:29 PM
Change colour of bars/lines in charts when data in rows/colums RodP Excel Programming 10 October 27th 05 05:07 PM


All times are GMT +1. The time now is 07:24 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"