+ Reply to Thread
Results 1 to 3 of 3

Macro Not Working On Filtered Data

  1. 06-24-2024, 04:02 AM #1
    HaroonSid
    HaroonSid is offline
    Forum Contributor HaroonSid's Avatar
    Join Date
    02-28-2014
    Location
    india
    MS-Off Ver
    Excel 2013
    Posts
    2,081

    Macro Not Working On Filtered Data

    hi,
    this code is not working on filtered data, otherwise working very well,
    plz help

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Use Code-Tags for showing your code :
    Please mark your question Solved if there has been offered a solution that works fine for you
    If You like solutions provided by anyone, feel free to add reputation using STAR *
    Reply With QuoteRegister To Reply
  2. 06-24-2024, 04:05 AM #2
    JohnTopley
    JohnTopley is online now
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,692

    Re: Macro Not Working On Filtered Data

    Where are the data sheets?
    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
    Reply With QuoteRegister To Reply
  3. 06-24-2024, 03:46 PM #3
    JEC.
    JEC. is offline
    Forum Expert
    Join Date
    10-11-2021
    Location
    Netherlands
    MS-Off Ver
    365
    Posts
    1,418

    Re: Macro Not Working On Filtered Data

    Only contiguous rows will be picked up with specialcells(12). Did not open your wb but try something like

    Please Login or Register  to view this content.
    Last edited by JEC.; 06-24-2024 at 03:48 PM.
    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)

Similar Threads

  1. [SOLVED] Working With Filtered Data
    By Jenn68 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 03-08-2022, 10:35 AM
  2. Macro that can filter excel data and copy the filtered data to another worksheet
    By glide2131 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-10-2013, 02:43 PM
  3. [SOLVED] Macro for delete filtered data
    By VKR in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-09-2013, 07:45 AM
  4. [SOLVED] Copying Filtered Data From 2 Sheets of One Workbook to Another Isn't Working Correctly
    By ScotyB in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-13-2012, 06:30 PM
  5. Excel 2007 : Auto serialing numbers in large filtered data for displaying filtered data
    By s.yasir in forum Excel General
    Replies: 4
    Last Post: 09-04-2012, 06:09 AM
  6. [SOLVED] Macro With Filtered Data
    By danderson2692 in forum Excel General
    Replies: 2
    Last Post: 06-14-2012, 09:46 AM
  7. Need a macro to filter data then email filtered data through lotus notes (or print)
    By Crimson Bourne in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-17-2012, 01:26 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