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?
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?
Code:
Sub clearswitchboard()
Sheets("general.switchboard").Select
RANGE("R57:AR155").Select
Selection.ClearContents
RANGE("af51").Select
End Sub