Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hopefully an easy one for someone
I would like to simplify this macro as is needs to go on for quite a few more repetitions. I'm hoping your able to spot the pattern. Short tables of 2x7 underneath each other, seperated by a line, that need to be sorted into order of the highest number in column AV first. I know it's a Do...Until or a For...Next, but i'm still a little inexperienced in these areas Range("AU16:AV22").Select Range("AV16").Activate Selection.Sort Key1:=Range("AV16"), Order1:=xlDescending, Header:=xlGuess _ , OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _ DataOption1:=xlSortNormal Range("AU24:AV30").Select Range("AV24").Activate Selection.Sort Key1:=Range("AV24"), Order1:=xlDescending, Header:=xlGuess _ , OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _ DataOption1:=xlSortNormal Range("AU32:AV38").Select Range("AV32").Activate Selection.Sort Key1:=Range("AV32"), Order1:=xlDescending, Header:=xlGuess _ , OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _ DataOption1:=xlSortNormal Range("AU40:AV46").Select Range("AV40").Activate Selection.Sort Key1:=Range("AV40"), Order1:=xlDescending, Header:=xlGuess _ , OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _ DataOption1:=xlSortNormal |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Simple problem, simple formula, no FUNCTION ! | Excel Worksheet Functions | |||
simple for each problem | Excel Programming | |||
Simple for.. next problem | Excel Programming | |||
Need help with a simple problem | Excel Programming | |||
A simple problem... | Excel Programming |