Run a macro when certain cells change

[arnie1066]

Basically i have tables A to H each of these table pulls data from a different series of cells, and then needs to be sorted with highest first etc.

The code to do the sort is complete, the problem is i have to assign it to an on screen button which is untidy. What i want to do is if any of the reference cells are changed then sort then tables.

I have tried various method but none quite work.
The closest was changing cells to trigger the code but that made the sheet flicker every time the current cell changed (eg moving from A1 to C4).

I did wonder if there was a special sub for on calculation like there is one for auto_open()

[DKenny]

You need to call your code from the Worksheet_Change event, checking to see if the Target range intersects with your reference cells.

Search this forum for Worksheet_Change and you will find lots of examples of how to do this.