+ Reply to Thread
Results 1 to 3 of 3

copy, paste visible cells after Auto filter- VBA

  1. 07-31-2015, 12:37 AM #1
    meus
    meus is offline
    Forum Contributor meus's Avatar
    Join Date
    11-25-2014
    Location
    kathmandu
    MS-Off Ver
    2010/ 2013
    Posts
    287

    copy, paste visible cells after Auto filter- VBA

    Hey all!
    After the Auto filter is applied on TABLE, i want to move just down the header of table for column"E" and copy formula from that and move till last visible row of table and apply formula just to visible rows......
    I have done till copying the formula but when i paste the formula, the unvisible cells are also affected so can anyone teach me learn on how to do this..
    Many thanks...

    Meus..
    Reply With QuoteRegister To Reply
  2. 07-31-2015, 01:07 AM #2
    mangesh.mehendale
    mangesh.mehendale is offline
    Valued Forum Contributor mangesh.mehendale's Avatar
    Join Date
    06-04-2015
    Location
    India
    MS-Off Ver
    2007
    Posts
    510

    Re: copy, paste visible cells after Auto filter- VBA

    Use this code to select only visible cell

    Please Login or Register  to view this content.
    Don`t care, take care...

    Regards,
    Mangesh
    Reply With QuoteRegister To Reply
  3. 07-31-2015, 01:59 AM #3
    sktneer
    sktneer is offline
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,655

    Re: copy, paste visible cells after Auto filter- VBA

    Try to adopt a logic something similar to this....

    See if this helps...

    Please Login or Register  to view this content.
    Regards
    sktneer

    Treat people the way you want to be treated. Talk to people the way you want to be talked to.
    Respect is earned NOT given.
    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. Copy Visible cells and paste values only to visible target cells
    By wotadude in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 09-20-2024, 12:01 AM
  2. [SOLVED] Copy Filter Data and paste it on another workbook with special cells(Only Visible Cells)
    By HaroonSid in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-13-2014, 07:59 AM
  3. [SOLVED] VBA - Filter, Copy and Paste Visible Columns If Cell has Value
    By gurlygal in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-30-2012, 08:10 AM
  4. Copy visible cells from Row B paste to Row A in filter mode
    By lakshmipathi123 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-21-2012, 03:37 PM
  5. [SOLVED] Vba Code: Copy Visible columns ( after using Auto Filter)
    By vidyuthrajesh in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-27-2012, 03:28 PM
  6. Sum according to Auto filter non visible cells
    By ElmerS in forum Excel General
    Replies: 9
    Last Post: 08-10-2009, 12:45 PM
  7. Fustration Help? Filter, Visible Copy/Paste
    By Craigm in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-19-2005, 02: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