Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi folks
I use macros using the record feature of Excel but dont know vis basic. I think i need some kind of simple for-loop to systematically go row by row and sort my columns in ascending order. It would look something like this. For Row = 1 to 2000, Step 1 Sort Row Code (see below cutout of actual code for doing just one row) Next I dont know how to write this code to make it increment row by row. Any help is greatly appreciated! Vincent Range("DW2:FR2").Select Selection.Sort Key1:=Range("DW2"), Order1:=xlAscending, Header:=xlGuess, _ OrderCustom:=1, MatchCase:=False, Orientation:=xlLeftToRight, _ DataOption1:=xlSortNormal |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Sort Columns of data at the same time, without regard to order. | Excel Worksheet Functions | |||
Excel 2007 calculate time between 2 date/time columns | Excel Discussion (Misc queries) | |||
macro from columns to rows but adding every time a new line | Excel Discussion (Misc queries) | |||
SORT MULTIPLE COLUMNS AT SAME TIME automatically | Excel Worksheet Functions | |||
Sort macro by same columns | Excel Programming |