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
Bookmarks