But if that's the definition, it skips after the line If Not Intersect (Target, Range("B4")) Is Nothing, to the "End If" when I make a manual update to cell B4, and doesn't go into my VBA Code. It keeps going in a loop between the If and End If statements.
And do I need to use an intersect when I only want to check if a single cell's value has been updated or is there a better way??
Also, if I'm using a worksheet_change event, does it calculate the entire workbook after running my vba code? (coz that's what seems to be happening to me here, and I don't understand why or how to stop it).

Thanks for the info