Sub Clearing()
results = MsgBox("Are you sure you want to clear the contents of this call score?", vbYesNo, "")
If results = vbYes Then
Range("E2:E7,G2:G7,H9:I9,H11:H87,H90:H95,H98:H102,H105:H108,E126:I126").ClearContents ""
Range("E2").Select
Save = MsgBox("Do you wish to save the file now?", vbYesNo, "")
If Save = vbYes Then
ActiveWorkbook.Save
End If
End If
When I run this macro, I get this error - Compile Error - Wrong number of arguments or invalid property assignment and highlights the first Range row.
This used to work and all I have done is changed E126:I126 from E123:I123, I don't understand why it now doesn't.
Bookmarks