On Sun, 30 Nov 2003 18:34:14 -0800, Todd Huttenstine wrote:

Ok I was not clear sorry. Let me try again...

I have columns M and N. The initial action will be in
ColumnM. ColumnN looks at the values in ColumnM.

In ColumnM, Values can be added, deleted, or the order in
which the values are listed can be switched around. If
the values in ColumnM are switched around, I dont want
ColumnN to swicth the values to Mirror ColumnM. The only
way the values in ColumnN can be modified is either if a
new value is added to columnM or a value is deleted from
columnM.

In the VBA editor, open up the Sheet (not a module). Paste in the code I
posted and change the line with sub's name to this:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)

My code can only handle rows 2-100 for column M, so if your data might
go beyond that, modify appropriately.
--
auric "underscore" "underscore" "at" hotmail "dot" com
*****
43% of all statistics are worthless.