Hi guys. Long time lurker, first time poster!
I've searched long and hard for a solution to this, but I'm just a derp when it comes to macros so I need some help.
I have a spreadsheet to keep track of daily jobs in progress. It consists of 6 tables (5 weekdays + 1 miscellaneous), each table lists customers, job descriptions, and details. The first column will have "D" for done or "I" for in progress. The macro is set up to automatically re-sort (Z to A) on cell changes so that anything marked "D" moves to the bottom. This all works great.
However, any time I clear cells or delete a row, Excel locks up. I'm sure it has something to do with the "Clear" commands listed below, but I removed those and it still screws up. Any ideas?
Thanks!
Andrea
Please Login or Register to view this content.
Bookmarks