I recorded the macro below.

I need a macro that will copy a group of cells. I select the firs
cell, say A11, and the macro takes over, selecting A11:N11 and copyin
the selection to A2 on Sheet3.
The problem with the macro is, it always selects A11:N11. I need it t
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 advanc

--
Archi
-----------------------------------------------------------------------
Archie's Profile: http://www.excelforum.com/member.php...fo&userid=3084
View this thread: http://www.excelforum.com/showthread.php?threadid=50504