On Thu, 22 Mar 2007 14:40:20 -0700, Mudragaddam
wrote:

i was trying to sort the data now

Sheet2.Range("A2:D65536")..Sort Key1:=Range("B1"), _
Order1:=xlAscending, Header:=xlGuess, OrderCustom:=1, _
MatchCase:=False,Orientation:=xlTopToBottom, DataOption1:=xlSortNormal

But it fails to sort the values in columns A to D.

I'm guessing you only have one Dev server, so it sorting - it's just that
nothing's changing. The data on Sheet2 isn't really suited to be sorted,
although it can be done. Two options: Sort the data on Sheet1, then it
will automatically be sorted on Sheet2. Sort each column on sheet2
independently, like

Range("B2:B65536").sort
Range("C2:C65536").sort
Range("D2:D65536").sort
and so on.


Thanks Again.....that was great...i am taking all the credit on behalf of you.

No problem.
--
Dick Kusleika
Microsoft MVP-Excel
http://www.dailydoseofexcel.com