Select Range to paste

[miles44]

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.

[zbor]

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here



(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)