hello.

I am trying to using a VB Userform to copy a selected row of cells from one workbook to another.

I have one variable "x" which dictates the row number of the row i want to copy.

Private Sub CommandButton1_Click()
Sub CopyOneArea()
Dim sourceRange As Range
Dim destrange As Range
Set sourceRange = Sheets("Sheet1").Range("AX:cX")
Set destrange = Sheets("Sheet2").Range(D7:II7)
sourceRange.Copy destrange
End Sub

End Sub

Obviousley the line Range("AX:cX") does not select the correct range and the "x" is treated as a letter.

Can anyone help.

Thanks in advance

Mike