I've looked everywhere. Is there a macro that someone has that can sort a
work sheet by one colum "P" where if it is blank all the blanks are at the
bottom and the filled in cells are at the top. Thanks

Ralph

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200702/1

Sub Macro1()
Range("P1:R10").Sort Key1:=Range("P1"), Order1:=xlAscending, _
Header:=xlGuess, OrderCustom:=1, MatchCase:=False, _
Orientation:=xlTopToBottom, DataOption1:=xlSortNormal
End Sub

Change range to suit. It put the blanks at the bottom for me.

Hth,
Merjet

Thanks that worked, what I would like to do is adda Worksheet change even to
run the macro when the worksheet is saved so I don't have to run it
automatically. Thanks

Ralph

merjet wrote:
Sub Macro1()
Range("P1:R10").Sort Key1:=Range("P1"), Order1:=xlAscending, _
Header:=xlGuess, OrderCustom:=1, MatchCase:=False, _
Orientation:=xlTopToBottom, DataOption1:=xlSortNormal
End Sub

Change range to suit. It put the blanks at the bottom for me.

Hth,
Merjet

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200702/1

That Excel sorts in this order:
numbers
text
blanks (sort to the bottom)
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware



"ralphdevlin via OfficeKB.com"
<u11047@uwe
wrote in message
I've looked everywhere. Is there a macro that someone has that can sort a
work sheet by one colum "P" where if it is blank all the blanks are at the
bottom and the filled in cells are at the top. Thanks

Ralph