Coping row by selecting rows with mouse in macro

[locojoe]

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.

 

[Paul B]

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 **