In this part of my macro, I have pasted the new values into the first empty row of the sheet and then I want to sort. When I run the code, it gives me a Run-time error '1004': Application-defined or object-defined error
The full sub code:
Sub NewProfile()
If PTBox.value = "" Then...