Is the problem directly related to deleting rows with values of less than 10?
If not, it would be better to start a new thread where you can outline your specific problem.
When quickly glancing through your code in your last post, I noticed an abundance of "Select" being used.
Maybe have a read here about it.

http://stackoverflow.com/questions/1...cel-vba-macros

Hi Joli,
Yes this is directly related. The code I sent opens various spreadsheets on the network and copies and pastes them to a Master spreadsheet. Each worksheet ends up with data. Anything line that has the number 10 of under needs to be deleted.
I'll attached a copy of the master for you to review.

If you look at the Holds Tab you will see under the column named Age their are a number of rows that have information 10 days or less. I need to automatically delete these rows. This will be the same for each Tab in the workbook. Would like it to be in one code so I can have a button that would make them work all at once along with the other things that happen in the code I sent you earlier!!!

Attached Files

JPM_Weekly_Exceptions_Data.xlsx (23.8 KB, 11 views)