| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
sort a column
hello
i am looking to sort a data table by column I. the amount of rows in column I will change over time. when i record this macro it send up an error (application or object is not defined). this all happens on sheet two of the worksheet in question. Can you help and let me know why this error is happening, i'm at a loss?! thank you - philip PS: code i have been using is... Sheets("Sheet2").Select Cells.Select Range("A1").Activate Selection.Sort Key1:=Range("I2"), Order1:=xlDescending, Header:=xlGuess, _ OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _ DataOption1:=xlSortNormal |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to sort entire spreadsheet by one column sort | Excel Discussion (Misc queries) | |||
| How to sort without including column headings in sort | Excel Discussion (Misc queries) | |||
| Auto-Sort Won't Sort All Column Cells | Excel Discussion (Misc queries) | |||
| data, sort option is grayed. how to sort on a column? | Excel Discussion (Misc queries) | |||
| How can I sort one column and have the entire row sort. (binding) | Excel Worksheet Functions | |||
Threaded Mode
