View Single Post
 
Old 07-16-2014, 09:34 AM
shilabrow shilabrow is offline Windows Vista Office 2007
Advanced Beginner
 
Join Date: Apr 2014
Posts: 45
shilabrow is on a distinguished road
Default

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.
Reply With Quote