Select your list and run:
Sub smith()
Dim savit()
ReDim savit(Selection.Count)
i = 0
foundit = False
For Each r In Selection
With r
If .Value = "smith" Then
foundit = True
Else
savit(i) = .Value
i = i + 1
End If
End With
Next
If foundit Then
i = 0
j = 0
For Each r In Selection
If j = 0 Then
Selection.Cells(1) = "smith"
j = 1
Else
r.Value = savit(i)
i = i + 1
End If
Next
End If
End Sub

Signature
Gary''s Student - gsnu2007
> hello ,
>
[quoted text clipped - 24 lines]
>
> thans
k743911@gmail.com - 19 Sep 2007 07:59 GMT
On Sep 18, 8:28 pm, Gary''s Student
<GarysStud...@discussions.microsoft.com> wrote:
> Select your list and run:
>
[quoted text clipped - 62 lines]
>
> - Show quoted text -
hi gary ,
thanks a lot ..