Question: what is the difference between worksheet_change and worksheet_selectionchange?
Answer: The Worksheet_Change event fires when content in a cell changes, while the Worksheet_SelectionChange event fires whenever a new cell is selected. Target is a parameter of data type Range (ie. ... If Target is not in the defined Range, nothing will happen in the worksheet.