Hi excelledsoftware, I notice something. When I paste exact amount of data range onto the Data sheet. It doesnt continue with other procedures because of;
The line FinalRow = 30000 'change to final row of data
- I think the line is saying sure you still fine within the 30000 range and since I have nothing to delete anymore am not processing other code.

When I change the line FinalRow = 29. It does paste and continue processing the other code. The only reason I dont like this is because its limits my paste option to 29 rows even if my clipboard data is larger than 29. I wouldnt want to be changing the FinalRow = ? everytime I want to run the code. I prefer a default no for varied options.

But If the range of row copied and pasted is less than the data in Data sheet, lets say the range of data copied is 20 rows and FinalRow = 29 the deletepastefunction works and continues to process the other clean code.

Is there a way to work around this to make them sync together. Thanks much for your help so far - I appreciate this greatly.