I found the below formula:
If Intersect(Target,Range(strRange)) IsNothing then Exit Sub
How does the function know to pick up the cell address for Target if the default is the value ?
Can someone explain the mechanics of the Intersect Function. I have googled it by I am struggling on why you would use this function...