Method Clear Contents of Object Range Failed

[ardykav]

Hi
I have the following simple code, never had an issue with it before but all of a sudden I am getting the "Method Clear Contents of Object Range Failed" run time error. From what I have read this isnt so much an error with the code but more to do with the system is that correct? If anyone knows a way around this it would be greatly appreciated

Sub Newstepclean()

   
    Sheets("Calculations").Select
    Range("K2:N7000").Select
    Selection.ClearContents
    Range("K2").Select

End Sub

 

[Fluff]

In that case I'm afraid I have no idea.

 

[Fluff]

@ardykav
Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. (rule 12 here: Forum Rules).
I have merged both threads.

 

[ardykav]

Apologies for that it wasnt so much the same question as the initial one was relating to what I thought was the code itself being an issue and then the second was a wider issue being systematic. Happy for them to be deleted though if you feel necessary.