View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Carlton A. Barlow Carlton A. Barlow is offline
external usenet poster
 
Posts: 9
Default Macro to sort numeric rows left to right

Column G should be the lowest value when sorting is complete.

"D." wrote:

Range("G15:AZ673").Sort Key1:=Range("G15"), Order1:=xlAscending,
Header:=xlGuess, _
OrderCustom:=1, MatchCase:=False, Orientation:=xlLeftToRight,
_
DataOption1:=xlSortNormal
End Sub
is column G the primary column?