::Thanks kaplan.

Is that code correct? I am getting some error.

Can you please modify my code. My code is :

SUB NAME()
'
' NAME MACRO
' MACRO RECORDED 3/14/2005 BY DINESH
'
' KEYBOARD SHORTCUT: CTRL+Q
'
RANGE(\\"A3:AZ28\\").SORT KEY1:=RANGE(\\"A4\\"),
ORDER1:=XLASCENDING, HEADER:= _
XLGUESS, ORDERCUSTOM:=1, MATCHCASE:=FALSE,
ORIENTATION:=XLTOPTOBOTTOM, _
DATAOPTION1:=XLSORTNORMAL
END SUB

Regards,
Dinesh Vijaywargiay::


--
dinesh


------------------------------------------------------------------------
dinesh's Profile: http://www.excelforum.com/member.php...o&userid=24177
View this thread: http://www.excelforum.com/showthread...hreadid=377989