Unfortunately, data is coming iut from 3 different tables. And at this time i do not have one more table whic I can define this key and sort in…And also if this problem solved I will be able to apply it to another solutions which will save for each solution a table to me… Update: xlRange:=xlWorksheet.Range(‘B1’); xlRange2:=xlWorksheet.Range(‘C1’); xlRange.Sort(xlRange,1,xlWorksheet.Range(‘C1’),xlRange2,1,xlWorksheet.Range(‘D1’),1,1,1,0,1,1); Using above lines makes my sorting for B,C,D respectively correct…But why I have to use 2 range automation ??? How can I make it in one Edited by - barcom on 2001 Mar 07 14:00:12