Quick question. I just realized that during my sort it goes from item
1 to item 10 then item 2 because its looking at just the digits not
the number as a whole. So is there a way to make it look at the whole
number my code is

With Sheets("Sheet1").Range("A1:E230")
.sort key1:=Sheets("Sheet1").Range("A1"), Order1:=xlAscending
End With

very simple!