Conditionally positioning arrays

Hi,

try this:

right click on the worksheet tab and click View code
in the VB editor, right hand side at the top select Worksheet from the object dropdown box
in the Procedure dropdown box select "Change"
Excel will create a procedure that looks like

Private Sub Worksheet_Change(ByVal Target As Range)

End Sub

put the code posted above into that procedure (leave out the first and last line of above code)

Now, whenever something changes in the worksheet, the code will run