Did you reformat the cells using the technique Bob Umlas suggested?

Jim Cone


I removed the line of text and the macro now runs, i also re formatted the
cells to numbers however it still sorts with the zeros as high numbers


"jimk" wrote:
I removed the line of text and the macro now runs, i also re formatted the
cells to numbers however it still sorts with the zeros as high numbers


"jimk" wrote:
Thanks I will try that when i get to work later, I still wonder why it worked
when it was written on 2003 and installed on the computer that ran 2000, but
after 4 months it quit working


"Jim Cone" wrote:
I believe that "xlSortTextAsNumbers" was added in XL2002.
Therefore, to run your sort code in XL2000 the last line
of the code should be deleted.
Jim Cone
San Francisco, USA



"jimk" wrote in message
...
Range("A3:M15").Select
Selection.Sort Key1:=Range("F4"), Order1:=xlDescending, Header:=xlGuess, _
OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _
DataOption1:=xlSortTextAsNumbers
this is the first step in the macro where it hangs up