How to get row numbers while updating multiple rows at the same time

[theaaru]

Whenever user updates some value in any column say $z$9 in Sheet1, i need to update the row number modified in Sheet 2. For this, i used Target.Row in Worksheet_Change and it is working fine.

But problem occurs while updating multiple rows at the same time using CTRL+V option. Event is firing for the first row only. Is there any way to get the row numbers which are updated?. If i use Target.Address, i can get the range ($Z$11:$Z$13). I am not sure how to take that row numbers i.e, 11 and 13. Is there any way?

Your help appreciated. Thanks.

 

[VoG]

Hello and welcome to MrExcel.

It is difficult to advise without seeing the code but you could try something like

Dim c As Range
For Each c In Target
    'here you can use c.Row
Next c

 

[theaaru]

Thanks VoG. You gave me the exact solution what i need.