• Paste() procedure: PasteSurname -> paste from where? What is it copying exactly?
• Adding call keyword to procedures is not needed anymore. It is redundant (refer to link at bottom of this post).
• I would also organise a bit more for readability like so:
Your error basically says the object property or method not supported. I would focus on Key:= argument in your sortfields method as that can often be the culprit.
Try: set rng=Range("J:J") alongside Dim rng as Range in your problematic modules: 5 and 6?
I would also refer to this on using Call - https://bettersolutions.com/vba/macr...ll-keyword.htm
Bookmarks