Results 1 to 1 of 1

VBA to Retain the Conditional Formatting with an Advanced Filter

Threaded View

  1. #1
    Registered User
    Join Date
    12-15-2011
    Location
    Dallas texas
    MS-Off Ver
    Excel 2010
    Posts
    45

    VBA to Retain the Conditional Formatting with an Advanced Filter

    Hi-

    iI've set up a macro to run an Advanced Filter that transfers entries to a separate worksheet (Sheet1) based on a date criteria. the source sheet (PM Project Tracker) has conditional formatting that i would like the VBA t oretain once on the new worksheet.

    is this possible? Any help would be appreciated.

    Attached is my code
    Sub FilterCopyToOtherSheet()
    Application.ScreenUpdating = True
    
    Sheets("Sheet1").Range("A6:AJ6000").ClearContents
    
         Sheets("PM Project Tracker").Range("A5:AJ250").AdvancedFilter _
         Action:=xlFilterCopy, _
         CriteriaRange:=Sheets("PM Project Tracker").Range("A3:B4"), _
         CopyToRange:=Sheets("Sheet1").Range("A6"), _
         Unique:=False
    
    
    End Sub
    Last edited by mmctague; 09-20-2012 at 11:26 PM.

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