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.
Help?![]()
Public Sub Reset_lastcell(wS As Worksheet) ActiveSheet.UsedRange wS.UsedRange End Sub
Bookmarks