In which case there's not a lot I can do sorry...
I would suggest when the error arises you hit debug and see the code in yellow - this will point you in the direction of the cause...
What I will say is that there appears to be a lot of superfluous code in the routine ... of more interest to you will be the various Offset commands which could easily cause bugs pending the active cell at point of code being executed... for ex. just looking at the first few lines, the below (line 3):
Will cause a bug if the active cell is anywhere in the first six rows when the code is invoked given you can not offset by more than 5 rows in an upwards direction (else you're moving off the workheet... ie to row 0 and under which don't exist).
Bookmarks