3 thoughts on “Filter by Selected Cell’s Value, Cell’s Color or Cell’s Font Color”

1. One has to be a bit careful when copying from a filter table

   The copy rules have changed in Excel 2007

   In Excel 2003 and below – When you copy from a filtered table only filtered cells get copied. The exception to this rule is if there are more than 8192 areas

   In Excel 2007 – When you copy from a filtered table
   – Only filtered cells get copied, provided you have selected the entire table and then applied a filter
   – Entire Table gets copied if you have selected only the header rows and then applied a filter

   The exception for the copy rule is also 8192 areas – in Excel 2007

   Sam

2. Hi Sam

   The example on my site will not work when you insert a table.
   I never use tables, but I will make it clear on the site and put a example for tables also.

   Thanks for your reply

3. Hi all

   I update the page today

   Code is working for a Table and a Normal range now.
   http://www.rondebruin.nl/colorfilter2007.htm

---

Posting code? Use <pre> tags for VBA and <code> tags for inline.