Need help in coding

[sumelectron]

Hi,
I have a special requirement. If I paste some value (be it any value) in a cell, then the cell 10 rows below should get selected.

I am an amateur at Excel programming and learning it now. Please help me out.

Regards,
~SumElectron

 

[syntaxed]

Hey sumelectron.

If you want the cell 10 rows below to be selected irrespective of whether the cell 10 rows above changes due to paste or some other reason, then the following code can work:

Private Sub Worksheet_Change(ByVal Target As Range)
Cells(Target.Row + 10, Target.Column).Select
End Sub

However, if you want it only to be selected in case of a paste, I don't believe Excel natively captures paste events. But the following link does contain a way of doing it:
http://www.mrexcel.com/forum/showthread.php?t=451174