I need help in deleting rows below what is pasted in a worksheet. If I paste data in A1 to Z500. I am wondering if upon paste, there can be a code to detect my new pasted data entries and delete any rows below new pasted data, if no rows below what is pasted then it should ignore. Is this possible? I will really appreciate all the help in getting this done. Thanks much.