+ Reply to Thread
Results 1 to 4 of 4

How to Ignore copy and paste if filter finding is empty, Please help

  1. 09-03-2016, 12:56 PM #1
    vinod2802
    vinod2802 is offline
    Registered User
    Join Date
    05-19-2014
    Posts
    35

    Post How to Ignore copy and paste if filter finding is empty, Please help

    How to Ignore copy and paste if filter finding is empty, Code mentioned below

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  2. 09-03-2016, 03:41 PM #2
    jaslake
    jaslake is offline
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: How to Ignore copy and paste if filter finding is empty, Please help

    Hi vinod2802

    Perhaps something like this...
    Please Login or Register  to view this content.
    John

    If you have issues with Code I've provided, I appreciate your feedback.

    In the event Code provided resolves your issue, please mark your Thread as SOLVED.

    If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.
    Reply With QuoteRegister To Reply
  3. 09-04-2016, 07:13 AM #3
    vinod2802
    vinod2802 is offline
    Registered User
    Join Date
    05-19-2014
    Posts
    35

    Re: How to Ignore copy and paste if filter finding is empty, Please help

    Im getting Compile error: Next without for. Can you please help


    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  4. 09-04-2016, 10:13 AM #4
    jaslake
    jaslake is offline
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: How to Ignore copy and paste if filter finding is empty, Please help

    Hi vinod2802

    Add the indicated line of Code...sorry about that.
    Please Login or Register  to view this content.
    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] Copy And Paste on Another Sheet ( next time paste data from empty row )
    By HaroonSid in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-17-2014, 02:29 AM
  2. Filter uniques and ignore empty cells
    By Tony Valko in forum Excel Programming / VBA / Macros
    Replies: 39
    Last Post: 12-30-2013, 10:08 PM
  3. Copy/Paste to Next Empty Row Overwriting Previous Row When Column A Is Empty
    By grantfitz in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-19-2013, 04:34 PM
  4. Vba - find next empty column, insert column, copy paste values & copy paste formulas
    By DoodlesMama in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-20-2012, 12:43 PM
  5. Excel 2007 : Filter row - copy it - and paste at the end of empty row on another work book.
    By nagumuthu in forum Excel General
    Replies: 1
    Last Post: 04-25-2012, 08:54 PM
  6. Copy and Paste - Ignore Blanks
    By V8Maverick in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 08-03-2010, 11:03 AM
  7. Finding next empty row to paste data
    By sentinela in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-24-2009, 03:46 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