What in the world??

Given this simple code

Code:

---

Application.EnableEvents = False
wsMon.Activate
wsMon.Range("C2:L2").ClearContents
Application.EnableEvents = True

---

what in the world could cause a runtime error 1004- ClearContents method of Range class failed?

Is Sheet-Protection on?

No, and wsMon is set to a worksheet that's not hidden.

I‘m out of ideas.
the last thing coming to mind is getting into cyclic „thingy“
you clear content in a range which triggers Change-Event which wants to write something into that range

G'Day ML

What about if you try

Worksheets("Sheet1").Range

And "hardcode" not using your var. wsMon

HTH