"Tonto" wrote in message
oups.com...

Hi

I am trying to sort the names based on the first three columns of
numbers.
first column, second column then third column.

Cheers


John

I don't see what sense there is in this cricumnstance, b.t.w.
this does the job:

Sub SomeSort()
ActiveSheet.[I45:O56].Sort _
Key1:=[I45], _
Key2:=[J45], _
Key3:=[K45], _
Order1:=xlAscending, _
Orientation:=xlSortColumns, _
MatchCase:=True
End Sub

Bruno