only watch J15 - J38... what am I missing

[dad812]

Please Login or Register  to view this content.

Have this code and I only want to watch for change in "J" rows 15-38, am I missing something.

Thanks in advance

[alansidman]

I think that you need to have this line of code

Please Login or Register  to view this content.

be

Please Login or Register  to view this content.

You didn't show it, but I am assuming that you are performing a Worksheet_Change event

[dad812]

it is in the Worksheet_Calculate() event