Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Seek assistance to convert the following macro code to loop the sorting from
col c thru col IV. Range("A1:IR2000").Select Selection.Copy Application.Goto Reference:="R11000C1" Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False Range("C11001:C12999").Select Application.CutCopyMode = False Selection.Sort Key1:=Range("C11001"), Order1:=xlAscending, Header:=xlNo, _ OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _ DataOption1:=xlSortNormal Range("D11001:D12999").Select Selection.Sort Key1:=Range("D11001"), Order1:=xlAscending, Header:=xlNo, _ OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _ DataOption1:=xlSortNormal End Sub Thank you. RobertR |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
looping through rows and columns | Excel Discussion (Misc queries) | |||
looping across columns in range? | Excel Discussion (Misc queries) | |||
Looping through columns | Excel Programming | |||
Looping thru columns beyond Z | Excel Programming | |||
Looping question for 2 columns | Excel Programming |