|Since I don't have your full code or workbook, I can't duplicate your error, but something doesn't look right to me.|
Are colNumA and colNumB numbers, e.g. 47 and 55? If so, then isn't
AutoSort_V3 Range(ColNumA, ColNumB)
referring to Range (47,55)? That's not a valid syntax for the Range property, so it's going to give you an error, probably an "Run-time error 1004 Application-defined or object-defined error"
Assuming that colNumA and colNumB are numbers, I was able to get this to work, but I really don't know if I am dealing with your issue or not.
colNum = Sheets("SheetA").Range("A33")
ColNumA = Cells(3, colNum - 5)
ColNumB = Cells(3, colNum + 2)
AutoSort_V3 Cells(ColNumA, ColNumB)
Public Sub AutoSort_V3(sortRange As Range)
'Place the string "myString" in whatever cell
'Cells(ColNumA, ColNumB) refers to. e.g. Cells(47,55)
Range(sortRange.Address) = "myString"
Now, if colNumA and colNumB are supposed to be the arguments for the Cells property like I used them, then using a variable that looks like it should be referring to a Column (colNumA) as the Row argument can be confusing.
Again, I'm not even sure if I am addressing your actual problem. You may need to provide a little more information, such as what values are being assigned to colNumA and colNumB by the first part of your code.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.