n8Mills
08-02-2007, 02:36 PM
Hello!
I am having a very bizarre error, starting today. When I use the code cells.select or columns("x:x").select then selection.delete on certain worksheets it will cause Excel to stop responding for about 5 minutes. It's very strange because I'm running the same Macros for 6 months and have never encountered this problem. I have also checked with coworkers and the same sheet that locks me up causes them no problems.
I have no idea how to diagnose this problem, does anyone else have some idea what this might be?
Thanks for any help,
Nate
I am having a very bizarre error, starting today. When I use the code cells.select or columns("x:x").select then selection.delete on certain worksheets it will cause Excel to stop responding for about 5 minutes. It's very strange because I'm running the same Macros for 6 months and have never encountered this problem. I have also checked with coworkers and the same sheet that locks me up causes them no problems.
I have no idea how to diagnose this problem, does anyone else have some idea what this might be?
Thanks for any help,
Nate