Results 1 to 1 of 1

Advanced Filter Problem

Threaded View

  1. #1
    Registered User
    Join Date
    04-20-2009
    Location
    NY , USA
    MS-Off Ver
    Excel 2003
    Posts
    5

    Angry Advanced Filter Problem

    8-23-2012 10-38-35 AM.png

    When the code below is run I'm not getting the green fill color on the newly added columns. The code worked fine until I added two columns to the spread sheet. The same two columns that won't take the fill color.

    Thanks for the help,
    Bernie

    Range("FR").AdvancedFilter Action:=xlFilterCopy, CriteriaRange:= _
            Sheets("Criteria").Range("ResubmtCrit"), CopyToRange:=Range("A8000"), Unique:= _
            False   '   Filter 1
    Last edited by arlu1201; 08-23-2012 at 10:51 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1