Assign an Excel Row to a VBA variable 1

[anet]

I am copying cells from one worksheet to another. If I hard code in a cell address it works fine. But I want to copy only certain cells from a row that the user selects. How do I assign the row ID to a variable.

Here is the code that I have so far:

Private Sub cmdPaySlip_Click()

Dim myRow As String 'is this the right datatype?

If Selection.Rows.Count = 1 And Selection.Columns.Count > 2 Then
'myRow = ????????? how do I do this?
Range(myRow, 4).Select 'is this right?
Selection.Copy
Sheets("Pay Slip&quot.Select
ActiveSheet.Range("B6&quot.Select
ActiveSheet.Paste
Else
MsgBox ("Please select a week to process.&quot
End If
End Sub

 

[RobBroekhuis]

Not sure what you are trying to do. This example should help, I think:

dim MyRow as integer
MyRow = selection.row
cells(MyRow,4).copy Sheets("Pay Slip&quot.Range("B6&quot

Rob

 

[anet]

Perfect! Thanks.