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