I've been struggling with this error message all day: Compile Error: Wrong number of arguments or invalid property assignment
I have a UserForm set up, and when I click submit, it runs some code (about 50 lines). However, it seems to get hung up in this section:
Sheets("Data").Visible = True
Worksheets("Data").Select
ActiveSheet.AutoFilterMode = False
Range("A3", Cells(ActiveSheet.UsedRange.Rows.Count), 1).Select
Selection.Replace What:=TicketNum, Replacement:=NewTicketNum, LookAt:=xlPart, SearchOrder:=xlByRows, MatchCase:=False
Range("B3", Cells(ActiveSheet.UsedRange.Rows.Count), 2).Select
Selection.Replace What:=CustomerName, Replacement:=NewCustomerName, LookAt:=xlPart, SearchOrder:=xlByRows, MatchCase:=False
Range("C3", Cells(ActiveSheet.UsedRange.Rows.Count), 3).Select
Selection.Replace What:=Vehicle, Replacement:=NewVehicle, LookAt:=xlPart, SearchOrder:=xlByRows, MatchCase:=False
It highlights the first "Range" above and gives me the compile error. I commented out that line, and re-ran. It went to the next "Range" and highlighted that with the same error message.
I did some research, and it seems the typical culprit would be for me to have declared a sub somewhere else called "Range". But I looked, and there is no such sub called Range.
Any idea, or maybe something to look at first? I can't seem to make any progress debugging this one. Thanks.
Bookmarks