Thread: sort macro
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Randy Starkey Randy Starkey is offline
external usenet poster
 
Posts: 16
Default sort macro

Hi,

Here's a sort macro I recorded. It works, but I'd like to change it to where
the bottom row it goes to (the column value is constant) is the last row
with content in column A.
================================
Sub Hospital_Sheet_Sort()
'
' Hospital_Sheet_Sort Macro
' Macro recorded 3/19/2005 by Randy Starkey
'

'
Range("A3:V361").Select
Range("V361").Activate
Selection.Sort Key1:=Range("A3"), Order1:=xlAscending, Key2:=Range("N3")
_
, Order2:=xlDescending, Header:=xlNo, OrderCustom:=1,
MatchCase:=False _
, Orientation:=xlTopToBottom, DataOption1:=xlSortNormal,
DataOption2:= _
xlSortNormal
Range("A3:A3").Select
End Sub
=================================

Could someone help me making that adjustment?

Thanks!

--Randy Starkey