Range(ActiveCell, ActiveCell.Offset(0, 13)).Select

should do the trick

Greetings from New Zealand
Bill K
"Archie" wrote in
message ...

I recorded the macro below.

I need a macro that will copy a group of cells. I select the first
cell, say A11, and the macro takes over, selecting A11:N11 and copying
the selection to A2 on Sheet3.
The problem with the macro is, it always selects A11:N11. I need it to
start where I choose, say, A17, then it selects A17:N17

Range("A11:N11").Select
Selection.Copy
Sheets("Macro").Select
Range("A2").Select
ActiveSheet.Paste
Application.CutCopyMode = False
Sheets("Form").Select
End Sub

Thanks in advance


--
Archie
------------------------------------------------------------------------
Archie's Profile:
http://www.excelforum.com/member.php...o&userid=30840
View this thread: http://www.excelforum.com/showthread...hreadid=505046