Copy from clipboard

[brent_milne]

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.

[Richard Buttrey]

Hi,

Maybe something like

Please Login or Register  to view this content.

Or a variation depending what you mean by first available blank row. This assumes Column A after the last item in column A.

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

[brent_milne]

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