steve case
Well-known Member
- Joined
- Apr 10, 2002
- Messages
- 823
I just got the first part to work here:
http://www.mrexcel.com/board2/viewtopic.php?t=180814&highlight=
Thank you all very much, and the next question is:
Is there a way to limit the range that this code:
Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
Target.Copy
Sheets("Sheet2").Range("A65536"). _
End(xlUp).Offset(1, 0).PasteSpecial Paste:=xlValues
Sheets("Sheet1").Select
End Sub
will copy?
Point and click in "A1:D10" and it works, outside of that range it doesn't.
Can this be done?
Like I said, I'm a Noob!
http://www.mrexcel.com/board2/viewtopic.php?t=180814&highlight=
Thank you all very much, and the next question is:
Is there a way to limit the range that this code:
Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
Target.Copy
Sheets("Sheet2").Range("A65536"). _
End(xlUp).Offset(1, 0).PasteSpecial Paste:=xlValues
Sheets("Sheet1").Select
End Sub
will copy?
Point and click in "A1:D10" and it works, outside of that range it doesn't.
Can this be done?
Like I said, I'm a Noob!