+ Reply to Thread
Results 1 to 2 of 2

Only apply code when row isn't hidden by autofilter.

  1. 03-04-2012, 01:33 PM #1
    dm@stams
    dm@stams is offline
    Registered User
    Join Date
    03-03-2012
    Location
    England
    MS-Off Ver
    Excel 2007
    Posts
    39

    Only apply code when row isn't hidden by autofilter.

    How can I amend the following code so that it only takes action when the row isn't hidden by an autofilter?

    Please Login or Register  to view this content.
    Thanks
    Reply With QuoteRegister To Reply
  2. 03-05-2012, 01:33 PM #2
    tkowal
    tkowal is offline
    Forum Contributor tkowal's Avatar
    Join Date
    11-20-2010
    Location
    Miami, Fl
    MS-Off Ver
    Excel 2010
    Posts
    150

    Re: Only apply code when row isn't hidden by autofilter.

    You may want to add to your if statement(s) to only process those rows that are not hidden.

    Example:
    Please Login or Register  to view this content.
    Hopefully this will help....
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1