THIS CODE WORKS GREAT BUT WHEN USING OTHER CELLS IT BUGS ALSO ITS RATHER LONG :( THANK YOU INADVANCE.
Private Sub Worksheet_Change(ByVal Target As Range)
' Check if the change occurred in cell B6 or B22 or B38 or B54
If Target.Address = "$B$6" Or Target.Address = "$B$22" Or...