tx shg for ur help, i tried tushar mehta's code, but application time error 1004 is coming, with following line highlighted there. "InArr = Application.WorksheetFunction.Transpose( _
Selection.Offset(2, 0).Resize(Selection.Rows.Count - 2).Value)"

kinldy help on this