Is your code in the SHEET1 Object?, or is it in a Module? I had a
similar problem, then cut/pasted all my code to a module and it worked
fine after that.

DK