range error

[KDS14589]

I'm new to VBA so be gentle.
This just started happening today.
Whenever I select a preexisting command button to a macro, I get an error window listing the range as "Wrong number of arguments or invalid property assignment"
What can I do now?

Sub clearswitchboard()
     Sheets("general.switchboard").Select
    RANGE("R57:AR155").Select
    Selection.ClearContents
    RANGE("af51").Select
End Sub

 

[igold]

Did you copy and paste your code into your post or did you type it in. The reason I ask is because if you copy and pasted the code, then the two places where the word "RANGE" appears would of have been changed to "Range" when the editor compiled the code. Are you sure you have the spelling of the worksheet "general.switchboard" exactly as it appears in your workbook.

If you manually typed your code into your post, and the worksheet name is correct then the code should run.

 

[DanteAmor]

The code works for me.
What version of Excel do you have?

 

[KDS14589]

Microsoft 0ffice Professional 2016

 

[KDS14589]

and it still doing it
I've also got all up-to-date

 

[igold]

Again, is the code in your OP a direct copy and paste from the VBE.

 

[DanteAmor]

Does the error point to any of the lines in the code?

 

[Peter_SSs]

As well as the unanswered questions above: What module is this code in?

 

[KDS14589]

it was every module

 

[igold]

@KDS14589

Just for the heck of it, could you answer my Post #6 , referring your Original Post...

If you do not understand the question, I could re-phrase it.