+ Reply to Thread
Results 1 to 2 of 2

Highlight Visible Cells from filtered column in a table

Hybrid View

  1. #1
    Forum Contributor
    Join Date
    08-08-2015
    Location
    North Carolina USA
    MS-Off Ver
    MS Office 2016
    Posts
    368

    Highlight Visible Cells from filtered column in a table

    Hi, I am trying to filter a table, and then highlight the visible cells from that specific column and column A red. Here is the code I have which is not working... ("Complaint Prepared = Column 18 Header and Column A = "Case #")

      ActiveSheet.ShowAllData
            ActiveWorkbook.Sheets("Sheet2").ListObjects("Table").Range.AutoFilter Field:=23, Criteria1:="<>"
            ActiveWorkbook.Sheets("Sheet2").ListObjects("Table").Range.AutoFilter Field:=18, Criteria1:="="
                        Range("Table[[#Headers],[Complaint Prepared ]]").Select
                    With Selection.Interior
                        .Pattern = xlSolid
                        .PatternColorIndex = xlAutomatic
                        .Color = 255
                        .TintAndShade = 0
                        .PatternTintAndShade = 0
                    End With
                Range("Table[[#Headers],[Case #]]").Select
                    With Selection.Interior
                        .Pattern = xlSolid
                        .PatternColorIndex = xlAutomatic
                        .Color = 255
                        .TintAndShade = 0
                        .PatternTintAndShade = 0
                    End With

  2. #2
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,259

    Re: Highlight Visible Cells from filtered column in a table

    Hello BG1983,

    You should attach your workbook. It is unlikely anyone will want to recreate your table. Such attempts are rarely close to the what you have already done.

    Posting a workbook will get you a workable solution to the problem.
    Sincerely,
    Leith Ross

    Remember To Do the Following....

    1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.
    2. Thank those who have helped you by clicking the Star below the post.
    3. Please mark your post [SOLVED] if it has been answered satisfactorily.


    Old Scottish Proverb...
    Luathaid gu deanamh maille! (Rushing causes delays!)

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] count auto filtered visible cells in column VBA...
    By gr8spot in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-28-2015, 09:55 AM
  2. Copy visible cells only from filtered
    By siobeh in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-20-2015, 09:39 AM
  3. Copy visible cells in filtered table and paste in userform textbox - email
    By pfeifferjoey in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-29-2014, 11:23 AM
  4. How to reference only visible cells once filtered
    By nuianderson in forum Excel General
    Replies: 1
    Last Post: 08-26-2013, 04:00 PM
  5. Replies: 4
    Last Post: 06-12-2013, 12:51 PM
  6. Formula in visible rows of filtered column
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-24-2009, 01:36 PM
  7. Loop in visible cells filtered
    By sal21 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-01-2008, 03:56 PM

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