Worksheet change not recognising target cell changes

[Ochimus]

Apologies if this has been covered previously, but have been unable to find a solution.

Col A on RANGES sheet lists three different meals. Cols B - D list the ingredients of each one.

Macro should be triggered if the DropList in C6 on the CALCULATOR sheet changes.
If the User clears the cell, it should delete any ingredients listed in Col D and exit the sub.
If the User selects a meal from the C6 Droplist, Macro should delete any ingredients in Col D, find the relevant list on the RANGES sheet, and copy those ingredients back to Col D on the CALCULATOR.

For whatever reason, the Macro is not "seeing" any change to C6, so nothing happens if you change or clear it.

Please Login or Register  to view this content.

All solutions, suggestions and alternatives welcome as ever

Ochimus

[Croweater]

If never gets past the line

Please Login or Register  to view this content.

because you are comparing an address to the contents of the cell.

Change it to this

Please Login or Register  to view this content.

[Ochimus]

Croweater,

Man thanks for prompt response and "seeing the wood for the trees". Now works perfectly.

Ochimus.

[Croweater]

No Problems.