Coping row by selecting rows with mouse in macro

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Just tring to write a macro to copy one row to another with some columns changed.
Can't figure how to mouse pick the second row, don't want to key in.
I can enter macro with one line selected but can't mouse pick destination row.
Need Help!
Thank you.
 
You can use a InputBox Type 8 to select your range something like this


Sub test()
Set RngCopy = Application.InputBox("Select the range to copy", Type:=8)
Set RngPaste = Application.InputBox("Select the range to paste to", Type:=8)
RngPaste.Value = RngCopy.Value
End Sub

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 97 & 2000
** remove news from my email address to reply by email **
 
Back
Top