+ Reply to Thread
Results 1 to 8 of 8

Button, paste in next availlable row, selection column b-g

  1. #1
    Registered User
    Join Date
    09-24-2012
    Location
    Johannesburg, South Africa
    MS-Off Ver
    Excel 2003
    Posts
    30

    Button, paste in next availlable row, selection column b-g

    Hi,

    What macro function paste data from clipboard in next availlable row, column b-g?

    That saves me some scrolling down to find the next availlable row when pasting 1500+ records.

  2. #2
    Forum Contributor stojko89's Avatar
    Join Date
    05-18-2009
    Location
    Maribor, Slovenia
    MS-Off Ver
    MS Office 365
    Posts
    913

    Re: Button, paste in next availlable row, selection column b-g

    last row in column:

    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    09-24-2012
    Location
    Johannesburg, South Africa
    MS-Off Ver
    Excel 2003
    Posts
    30

    Re: Button, paste in next availlable row, selection column b-g

    Quote Originally Posted by stojko89 View Post
    last row in column:

    Please Login or Register  to view this content.
    Hi, I tried this but it doesnt paste the content of the clipboard unfortunately. It pastes blank cells.
    Note that it should paste in column B - G on the worksheet on the next empty row in B-G.

  4. #4
    Forum Contributor stojko89's Avatar
    Join Date
    05-18-2009
    Location
    Maribor, Slovenia
    MS-Off Ver
    MS Office 365
    Posts
    913

    Re: Button, paste in next availlable row, selection column b-g

    This code doesn't past anything...This code just moves you to the next awailable row in the active sheet in column B.
    You didn't give me anything to work with to know what gets pasted from where to B - G.

  5. #5
    Forum Contributor stojko89's Avatar
    Join Date
    05-18-2009
    Location
    Maribor, Slovenia
    MS-Off Ver
    MS Office 365
    Posts
    913

    Re: Button, paste in next availlable row, selection column b-g

    If you want I can take a look at your sample workbook? to see what get copyes where. or if column B - G on sheet 1 gets copyed to B - G on sheet 2 I have another solution for you

  6. #6
    Registered User
    Join Date
    09-24-2012
    Location
    Johannesburg, South Africa
    MS-Off Ver
    Excel 2003
    Posts
    30

    Re: Button, paste in next availlable row, selection column b-g

    Its copying the clipboard data. Not from a sheet.

    I extract data from a program that makes an excel book. (names it randomly book1 book2 etc etc)

    So I copy from there (I select manually, copy, goes to clipboard)

    And then I need to paste it in column B-G

    I do it again to get more data

    Then copy in next available row in B-G under the previously pasted data.

    Hope that's clear.

  7. #7
    Forum Contributor stojko89's Avatar
    Join Date
    05-18-2009
    Location
    Maribor, Slovenia
    MS-Off Ver
    MS Office 365
    Posts
    913

    Re: Button, paste in next availlable row, selection column b-g

    What about this:
    Please Login or Register  to view this content.

  8. #8
    Forum Contributor stojko89's Avatar
    Join Date
    05-18-2009
    Location
    Maribor, Slovenia
    MS-Off Ver
    MS Office 365
    Posts
    913

    Re: Button, paste in next availlable row, selection column b-g

    Later if it works you can remove the lRow.Select <<<-----This is just so it scrolls you down to the last row and you can see if it paste the content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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