Hello,
I have a code to copy and paste value to other cells, If you could help me figure out when it pasted values to other cells. I want it to paste with sorted values from A-Z. Below is my code and appreciate if you can help.
Sub Copy_Family()
Sheets("Summary").Activate
Range("F3:F25").ClearContents
Dim col As Collection
Set col = New Collection
Dim rB As Range, rO As Range
Set rB = Range(Range("B32"), Range("B32").End(xlDown))
Set rO = Range("F3")
For Each r In rB
On Error Resume Next
col.Add r.Value, CStr(r.Value)
If Err.Number = 0 Then
rO.Value = r.Value
Set rO = rO.Offset(1, 0)
End If
Next r
End Sub
Bookmarks