LinkBack URL
About LinkBacks
I am looking for a macro that will past the contents of what I have copied to the clipboard into the first available blank row on a worksheet. Thanks for any help.
I am looking for a macro that will past the contents of what I have copied to the clipboard into the first available blank row on a worksheet. Thanks for any help.
Hi,
Maybe something like
Formula:
Range("A" & Rows.Count).End(xlUp).Cells(2, 1).PasteSpecial (xlPasteAll)
Or a variation depending what you mean by first available blank row. This assumes Column A after the last item in column A.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Maybe:
Range("A" & rows.count).End(3)(2).PasteSpecial xlPasteAll
Thanks for the reply but I just was informed that what I am pasting is coming from a table in a webpage and not straight data. So I am copying a row or rows from a table (with 11 columns) from a page to the clipboard and need a macro to paste this in the next available row on a worksheet. Sorry about changing my request but management changed their mind and just let me know now
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks