What can I append
David,
You could try names in the format:
39LASTNAME,FIRSTNAME.
A sort ascending would keep your numbers sequential.
Another way is to use a hidden column with just the numbers in and sort your
range on that column.
E.g. A1 = Lastname56,Firstname and X1 = 56. Sort on column X
Henry
"David" wrote in message
...
I have a workbook laid out in such a way that this will append numbers to
dummy names the way I want:
Sub AppendNumber()
c = 36
For i = ActiveSheet.UsedRange.Rows.Count - 14 To 3 Step -15
Range("A" & i).Value = "LASTNAME" & c & ", " & "FIRSTNAME"
c = c - 1
Next
End Sub
Problem is that another routine that ends up sorting my range Ascending
screws up the numeric order of the appended numbers, ex: last name in the
sorted list winds up as LASTNAME9, FIRSTNAME
Is there something else I can append to the names that will allow a proper
sort?
--
David
|