+ Reply to Thread
Results 1 to 5 of 5

Required help in modifying the code.. (COPY & PASTE)

  1. #1
    Forum Contributor
    Join Date
    06-01-2015
    Location
    Chennai,India
    MS-Off Ver
    EXCEL 2013
    Posts
    132

    Talking Required help in modifying the code.. (COPY & PASTE)

    Hi all,

    I have the below subroutine wherein it will paste the data from one workbook to another workbook based on the used range however it was working fine so far but now i am facing challenges on the same.

    > Previously, I was having more than 10000 line items in "control report" wherein it will automatically paste in the "master file" sheet below the used range.

    > Currently, i have deleted all those 10000 line item since i don't need the old data but now the challenge is, it is not pasting in the 2nd row since i wrote the code as "it should paste the data below the used range" but now only headers are available wherein now i am expecting to paste those data in the row 2.

    > It was working when 10000 line items was available but now it is not working when only headers are available in the report.

    Can someone help me on this to modify the code.

    Please Login or Register  to view this content.
    Last edited by Revathi kannan; 01-15-2019 at 09:01 AM.

  2. #2
    Forum Guru
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,032

    Re: Required help in modifying the code.. (COPY & PASTE)

    Your post does not comply with Rule 2 of our Forum RULES. Use code tags around code.

    Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

    Click on Edit to open your thread, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

    (This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 6)
    Please Avoid Joining My List Of Blocked Users by:

    Saying Please and Thank you.

    Making requests not demands.

    Checking back on your post. I will not edit any post after 4 days.

    Marking threads as closed once your issue is resolved. How? The tools at the top

    Any reputation (*) points appreciated. None of us gets paid here.

    If you found someone's input useful, please take a second to click the * at the bottom left to let them know

  3. #3
    Forum Contributor
    Join Date
    06-01-2015
    Location
    Chennai,India
    MS-Off Ver
    EXCEL 2013
    Posts
    132

    Re: Required help in modifying the code.. (COPY & PASTE)

    Thank you for the assistance. I have made the changes as per the forum rules.

  4. #4
    Forum Guru
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,032

    Re: Required help in modifying the code.. (COPY & PASTE)

    The important two lines are:

    Please Login or Register  to view this content.
    Add one more line

    Please Login or Register  to view this content.

  5. #5
    Forum Contributor
    Join Date
    06-01-2015
    Location
    Chennai,India
    MS-Off Ver
    EXCEL 2013
    Posts
    132

    Re: Required help in modifying the code.. (COPY & PASTE)

    I am still getting run time error..

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Help modifying code to copy data from one sheet to another
    By PitBoo in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-28-2018, 08:37 AM
  2. [SOLVED] Help modifying code to copy data from different workbooks to this workbook.
    By UPA in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 06-10-2018, 02:41 AM
  3. Modifying VBA copy and paste code to search down rather than across
    By Stopwatch in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 07-07-2015, 11:45 AM
  4. [SOLVED] Help with modifying code to copy specific cells on target row instead of the whole row
    By Spookman in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-28-2012, 05:22 AM
  5. code required to copy and paste rows matching a criteria.
    By Duguid1 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-30-2008, 04:49 AM
  6. copy and paste help required
    By khalid79m in forum Excel General
    Replies: 4
    Last Post: 01-06-2007, 09:52 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