Closed Thread
Results 1 to 4 of 4

Filter doesn't filter range?

  1. 02-22-2018, 04:37 PM #1
    RustyNail
    RustyNail is offline
    Forum Contributor
    Join Date
    03-07-2013
    Location
    Montreal
    MS-Off Ver
    Excel 2007
    Posts
    274

    Filter doesn't filter range?

    Hello,

    Why after these lines does VBA apply the filter to all the rows on my spread sheet when all I ask is to apply the filter to only the A6-A10 range?

    Please Login or Register  to view this content.

    All help appreciated

    Thanks
    RN
    Reply With QuoteRegister To Reply
  2. 02-22-2018, 04:54 PM #2
    mrice
    mrice is offline
    Forum Expert mrice's Avatar
    Join Date
    06-22-2004
    Location
    Surrey, England
    MS-Off Ver
    Excel 2013
    Posts
    4,967

    Re: Filter doesn't filter range?

    This can be prevented if you have row 11 as blank.
    Martin
    Reply With QuoteRegister To Reply
  3. 02-22-2018, 05:41 PM #3
    RustyNail
    RustyNail is offline
    Forum Contributor
    Join Date
    03-07-2013
    Location
    Montreal
    MS-Off Ver
    Excel 2007
    Posts
    274
    Quote Originally Posted by mrice View Post
    This can be prevented if you have row 11 as blank.
    But A11 is not part of the requested range????

    And in any case A11 cannot be blank...
    Reply With QuoteRegister To Reply
  4. 02-27-2018, 01:51 AM #4
    AliGW
    AliGW is online now
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,830

    Re: Filter doesn't filter range?

    Duplicate threads are not allowed. Please continue in the other thread here: https://www.excelforum.com/excel-gen...per-range.html
    Ali

    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
Closed Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Advanced Filter Code : Criteria Range More Than 1 Row Breaks Filter
    By PaulGW in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-10-2021, 04:30 PM
  2. Inserting filter into pivot table via macro errors if filter doesn't exist.
    By taylorsm in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-03-2018, 10:24 AM
  3. VBA Advanced Filter - Two Filters Without Deleting Bottom Filter Data In Same Column Range
    By hysterical.useless in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-14-2017, 02:54 PM
  4. Auto filter sometimes doesn't filter and sometimes only partially filters
    By johnnyjomp in forum Excel General
    Replies: 4
    Last Post: 04-29-2015, 02:00 PM
  5. Filter several pivot tables by one programmed date range filter in Excel 2003
    By olewka in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-08-2011, 11:49 AM
  6. [SOLVED] Excel auto filter doesn't recoginize case - won't filter AA from A
    By Mikey in forum Excel General
    Replies: 1
    Last Post: 09-29-2005, 04:05 PM
  7. Auto Filter Delete Rows by Criteria Doesn't Work Range To Complicated
    By robertjtucker in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-29-2005, 01:05 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1