Limiting the calculations to one or two columns in Worksheet_Change

[Philosophaie]

I am using the Sub Worksheet_Change. I want to limit the columns that it calculates to the 3rd and 4th column. How doI do that?

 

[Jonmo1]

Look into using the INTERSECT function...

If Intersect(Target, Range("C:D")) Is Nothing Then Exit Sub

That will make it exit the code if the changed cell is not within columns 3 and/or 4


Hope that helps.