Paul,

You haven't got a space and an underscore character at the end of the first
line... I think!

regards

Pete



"Paul Cooke" wrote:


Would someone mind heaving a look at this segment of code and letting me
know if they can see whats wrong with it please.

Many thanks


Paul


'Sort by ID number
Range("A1").CurrentRegion.Sort Key1:=Range("F2"), Order1:=xlAscending,
Header:=xlYes, _
Orientation:=xlTopToBottom


--
Paul Cooke
------------------------------------------------------------------------
Paul Cooke's Profile: http://www.excelforum.com/member.php...o&userid=29268
View this thread: http://www.excelforum.com/showthread...hreadid=491797