Results 1 to 9 of 9

Thread: VBA To Extract Latest X Number Of Rows From A Range and Paste To Another

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. 04-13-2014, 02:38 PM #9
    Rick Rothstein
    Rick Rothstein is offline
    Forum Guru Rick Rothstein's Avatar
    Join Date
    Feb 2012
    Posts
    662
    Rep Power
    15
    This single code line should also work...

    Code:
    Cells(Application.Max(1, Cells(Rows.Count, "A").End(xlUp).Row - 499), "A").Resize(500, 6).Copy Range("H1")
    Last edited by bakerman; 04-14-2014 at 05:22 AM. Reason: Code tags added for readability
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Similar Threads

  1. Copy/Paste Excel Range/Chart into Powerpoint VBA
    By Admin in forum Excel and VBA Tips and Tricks
    Replies: 1
    Last Post: 03-13-2014, 02:59 PM
  2. VBA to Copy Rows Until Blank Row and Paste Data on First Blank Row
    By melissa1113 in forum Excel Help
    Replies: 2
    Last Post: 03-08-2014, 02:49 AM
  3. Sort Range Using VBA And Ignoring Or Discarding Blank Rows
    By analyst in forum Excel Help
    Replies: 18
    Last Post: 02-12-2014, 10:47 AM
  4. VBA To Extract Certain Rows From A Text File
    By Bogdan in forum Excel Help
    Replies: 4
    Last Post: 08-31-2013, 06:57 PM
  5. Macro Copy Columns and Paste in rows.
    By TommyKris in forum Excel Help
    Replies: 3
    Last Post: 03-06-2013, 02:36 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