• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

range error

kds14589

New Member
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?rangeError.png
 
may be this macro can you help (the selection method Not necessary)
Code:
Option Explicit
Sub test()
    With Sheets("general.switchboard")
      .Range("R57:AR155").ClearContents
      .Range("AF51") = "OK" '====>>> Change as you like
    End With
End Sub
 
Back
Top