In a workbook I have multiple worksheets and I can code it
to do a certain things on the change function of each
worksheet, But if I change any cell the code runs, what I
am looking for is something that when I change a
particular value in a range say from B3 to Z3, if any of
those values are changed then I want my code to run,
otherwise ignore it.

so for example the user changes the value in cell C5
nothing happens, but they then change the value in cell P3
the code will run

Hope this is clear. Also where would I put the code to
make it work on the worksheet or in a module

Thanks