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