Auto Sort Range of Cells

[caj1980]

I have seen several posts that answer my question but I am not smart enough to tweak the code to fit my cell range. Could someone please help me write the script to put in my VBA code to auto-sort Range A9:D17 any time a value in Column D changes. Note that Column D cells are actually formulas that reference other cells in the workbook (=Sheet2!D7). Thanks!

	A	B	C	D
9	Johnson	1	6	486
10	White	5	7	452
11	Peden	8	5	385
12	Shearin	4	4	245
13	Roberts	9	9	132
14	Donaldson	3	2	120
15	Rodriguez	7	1	84
16	Catalano	4	6	42
17	Butler	8	3	12

<tbody>
</tbody>

 

[caj1980]

clarification: sort range A9:D17 based on values in Column D, triggered by any change to Column D

 

[caj1980]

I figured this one out on my own

 

[ZVI]

Was it this one?

' Put this code into the sheet's module
Private Sub Worksheet_Calculate()
  Range("A9:D17").Sort Range("D17"), xlAscending, Header:=xlNo
End Sub