Results 1 to 3 of 3

Increase copy and paste range after each loop

Threaded View

  1. #1
    Registered User
    Join Date
    02-25-2014
    Location
    San Diego, Californa
    MS-Off Ver
    Excel 2007
    Posts
    4

    Increase copy and paste range after each loop

    I want to make the code below loop and each time it does Sheet1 copy Range increases by 18 rows while Sheet2 paste range increases by 1 row until the macro finds an empty range (without contents) in Sheet1, Can you help?

    Sheets("Sheet2").Range("C2:R2").Value = _
    Sheets("Sheet1").Range("C6:C21").Value
    Last edited by JakeSn; 02-27-2014 at 05:35 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Copy dynamically changing column and Paste using VBA Loop (Loop within Loop)
    By nixon72 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-12-2013, 12:46 PM
  2. Copy and paste named range at end of loop causing massive slowdown over time
    By Sccye in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-12-2013, 07:03 AM
  3. Setting a range within a loop variable for copy/paste
    By Craig in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-21-2005, 12:10 PM
  4. [SOLVED] Setting a range within a loop variable for copy/paste
    By Craig in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-20-2005, 06:25 PM
  5. [SOLVED] Loop: Copy and paste range that changes with every iteration
    By Allen Geddes in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-15-2005, 09:10 AM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1