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.
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.
last row in column:
Please Login or Register to view this content.
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.
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
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.
What about this:
Please Login or Register to view this content.
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks