I have a baseball game I've created using Excel. I would like a MACRO that will copy several rows/columns of stats from one sheet to another. It would paste the stats in the cells on the 2nd sheet in the range reference by cell A1 of the 2nd.
Each team will begin with a different row number.
For example, I have (25, 3) in A1 and C25 is where I want the "paste" to begin. I'm having trouble getting it to work.
The first range is from the "PLAY GAME" sheet.
Here's what I have:
Sub MoveVHitStreak()
'
' MoveVHitStreak Macro
'
Dim First As String
'
Range("BF71:BN89").Select
Selection.Copy
Sheets("Hitting Streaks").Select
First = cells(1, 1)
Range(First).Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Calculate
End Sub
Thanks for any help you can give.
Bookmarks