Copy and Paste to Last Row

  • Greetings friends.


    Not sure why but my code will not continuously add data to the Last Row in a Column. It simply loops through all the data pasting only the final result.


    Example.


    It should have pasted 200 values to the bottom of my list. But it just changes the value of the Last row to the value of the 200th result.


    Here is my code. I can;t see whats wrong.


    [SIZE=3]The Only Dumb Question Is A Question Not Asked.[/SIZE]

  • Re: Copy and Paste to Last Row


    You found the last (used) row, no problem. But not too sure your existing syntax would work too well.


    Surely, it should be

    Code
    c.Copy Sheets("GP-MP").Range("C" & Last_Row + 1)

    or something similar...?

  • Re: Copy and Paste to Last Row


    I have it sorted now, thanks for the push in the right direction Cytop.


    Code
    c.Copy Range("C" & Last_Row + 1)
      Last_Row = Last_Row + 1

    [SIZE=3]The Only Dumb Question Is A Question Not Asked.[/SIZE]

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!