Run the macro from the VBA ide. When the program seems to lock up hit <CTRL><BREAK>, the program will stop, the VBA ide will pop up with the the cursor in the section of code containing the error.
Hopefully you'll be able to see the problem, once you know where it is. Use some break points, etc.
Hard to comment on the actual problem without a peek at the code - perhaps you could post the offending routine here?
Regards,
td
|