+ Reply to Thread
Results 1 to 10 of 10

Paste in last row of column A

  1. #1
    Forum Contributor
    Join Date
    08-01-2012
    Location
    rotterdam, holland
    MS-Off Ver
    Excel 2013
    Posts
    170

    Paste in last row of column A

    I want my userform to paste the values of all the info in my userform in one straight row and ofcourse the last empty row. So for example combobox 2 (pasting in column B) right next to the last row of column A in column B, how do I do that? It's now pasting to each last empty cell in each single column. So for example it has to skip the blank cells in column B if you know what I mean. Thanks!

    Mirjam v1.xlsm

    Please Login or Register  to view this content.

  2. #2
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: Paste in last row of column A

    Please Login or Register  to view this content.

  3. #3
    Forum Expert Debraj Roy's Avatar
    Join Date
    09-27-2012
    Location
    New Delhi,India
    MS-Off Ver
    Excel 2013
    Posts
    1,469

    Re: Paste in last row of column A

    I have not checked all the codes.. however..

    Try to add like this..

    Please Login or Register  to view this content.
    Last edited by Debraj Roy; 11-27-2014 at 07:14 PM.
    Regards!
    =DEC2HEX(3563)

    If you like someone's answer, click the star to give them a reputation point for that answer...

  4. #4
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: Paste in last row of column A

    Option Explicit and the varaible r do not get together.

  5. #5
    Forum Expert Debraj Roy's Avatar
    Join Date
    09-27-2012
    Location
    New Delhi,India
    MS-Off Ver
    Excel 2013
    Posts
    1,469

    Re: Paste in last row of column A

    OOPS.. my fault..

    I was busy in coloring Veriable parts..

    Now edited..

  6. #6
    Forum Contributor
    Join Date
    08-01-2012
    Location
    rotterdam, holland
    MS-Off Ver
    Excel 2013
    Posts
    170

    Re: Paste in last row of column A

    Both didnt work.
    The first code doesnt skip the empty cells. So cells are in different rows.
    Mirjam v1.xlsm

    Please Login or Register  to view this content.
    this code gives me an error.

    Please Login or Register  to view this content.

  7. #7
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: Paste in last row of column A

    You need to explain why rather than both did not work.
    The code you have paste in to next rows in each columns, A,B, C and so on

    Please Login or Register  to view this content.
    Roy's code is different. It finds the next empty cell in column A and use that row to paste other columns.
    I am not sure what is empty cell

  8. #8
    Forum Contributor
    Join Date
    08-01-2012
    Location
    rotterdam, holland
    MS-Off Ver
    Excel 2013
    Posts
    170

    Re: Paste in last row of column A

    I used your above code, but its not pasting the values in the same row, but different ones. See for yourself : Mirjam v1.xlsm
    Fill in Label some tekst, and choose for example: at the combobox: 'Service' or 'Meerwerk'. Then on 'Toevoegen'. You will see it's adding the data in different rows.
    I want all the data in the same row. How do I do that? Thanks!

  9. #9
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: Paste in last row of column A

    You have already a line of code on one of user forms.
    Please Login or Register  to view this content.

  10. #10
    Forum Contributor
    Join Date
    08-01-2012
    Location
    rotterdam, holland
    MS-Off Ver
    Excel 2013
    Posts
    170

    Re: Paste in last row of column A

    sweet! thanks! +rep

+ 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. Replies: 5
    Last Post: 08-01-2014, 04:30 PM
  2. Replies: 3
    Last Post: 05-22-2013, 01:08 AM
  3. Vba - find next empty column, insert column, copy paste values & copy paste formulas
    By DoodlesMama in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-20-2012, 12:43 PM
  4. -- Selective Cut and Paste -- Cut and Paste based off of B Column's Content --
    By brad70989 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-09-2011, 03:29 PM
  5. Replies: 4
    Last Post: 08-31-2010, 10:48 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1