Given this simple code
what in the world could cause a runtime error 1004- ClearContents method of Range class failed?Code:Application.EnableEvents = False
wsMon.Activate
wsMon.Range("C2:L2").ClearContents
Application.EnableEvents = True
Printable View
Given this simple code
what in the world could cause a runtime error 1004- ClearContents method of Range class failed?Code:Application.EnableEvents = False
wsMon.Activate
wsMon.Range("C2:L2").ClearContents
Application.EnableEvents = True
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