I tried to use macro recording and after I viewed the codes, I didn't think anything was wrong.
The goal I wanted was that to keep the selection of the selected cells/ranges to be copied in excel clipboard. The code looked like this:

Sub Copy_Scores()
'
' Copy_Scores Macro
' CopyScores in Clipboard
'

'
    Range("M11:V11,Z11:AI11,AM11,M13:V27,Z13:AI27,AM13:AM27").Copy
    Range("am13").Activate
    
End Sub
The code, as you can see wishes to exclude the columns W, X, Y, AJ, AK, and AL. Also, I don't wish to select everything that is found in Row 12.

However, when I tried to paste in on any other sheet, it contains all the columns and rows which where in selected all within M11:AM27.

PS

I do not wish to put a paste function in the macro since I'm really not sure where or what particular file or sheet I would be pasting the said data.