There's a macro on this thread that I need to run on multiple workbooks. I've made a button in my excel that runs it, but I get the error "Argument is not an option" when I try to run it.

Public Sub Reset_lastcell(wS As Worksheet)
    ActiveSheet.UsedRange
    wS.UsedRange
End Sub
Help?