Macro Recording: Copy Ranges

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.

Originally Posted by 6StringJazzer

You get exactly the same behavior as if you selected those cells, copied, and then pasted. You might want to try that and see how it works.

It includes exactly what you specify. However, when you paste, the shape is not preserved. That is, the data is pasted into a solid block instead of skipping columns that correspond to the columns skipped in the copy operation.

Oh man! I just did that and you were right.. damn!

Do i have any other choice here? I mean is there any way I would be able to do what I wanted to happen?

Suggestions please..

Hard to say without knowing your whole data layout and what you are trying to do. What is in cells in the range M11:AM27 that are not included in the copy range? What is in the corresponding cells in the destination range?

Because you are not controlling the paste operation from your code, it is difficult (or maybe impossible). You could copy the entire range as a single block to the clipboard, but I don't know if that will then include other cells that you don't want, or overwrite cells on the paste operation that you want to preserve.

Originally Posted by 6StringJazzer

Hard to say without knowing your whole data layout and what you are trying to do. What is in cells in the range M11:AM27 that are not included in the copy range? What is in the corresponding cells in the destination range?

the cells which are not included in the range are actually two types.. the first one is that Row 12 is actually a spacer between two categories.. since Row 11 is the header which includes different names that vary depending on the user input. the other rows which i wish to exclude is the tally of all the values that are found among the tables. example, M13:V27 are numbers which needed to be analyzed by the columns W, X and Y.