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