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