View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
havocdragon havocdragon is offline
external usenet poster
 
Posts: 75
Default Manually editing Sort function in VBA

I Have beem attempting to manually do my own sorting in VBA, but to no
avail. So I record a macro that sorts, and that works fine. BUT, if I want
to edit it, it no longer works, also, If I manually type the EXACT same
arguement , it doesnt work. The only thing that works so far in VBA, is just
running the macro and cutting it and pasting it to my macro.

Here is what excel records

Rows("1:11").Select
Selection.Sort Key1:=Range("A2"), Order1:=xlDescending, Key2:=Range("B2") _
, Order2:=xlDescending, Header:=xlYes, OrderCustom:=1,
MatchCase:=False _
, Orientation:=xlTopToBottom, DataOption1:=xlSortNormal,
DataOption2:= _
xlSortNormal