Results 1 to 9 of 9

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

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. 04-11-2014, 05:50 PM #1
    mrprofit
    mrprofit is offline
    Member
    Join Date
    Apr 2014
    Posts
    45
    Rep Power
    0
    My solution,

    Code:
    If Sheets("Sheet1").Cells(Rows.Count, 2).End(xlUp).Row >= 500 Then
       Range("A" & Rows.Count).End(xlUp)(-498).Resize(500, 6).Select
    Else
 Range("A1:F500").Select
.....
End IF
    Last edited by mrprofit; 04-11-2014 at 05:55 PM.
    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