Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sort data whilst autofiler is on
Hi,
I would like to sort all of my data whilst the autofiler is on. I currently have to clear the autofilter to select all the data, as... Range("A5:P" & Cells(Rows.Count, "A").End(xlUp).Row).Select Selection.Sort Key1:=Range("C6"), Order1:=xlAscending, Header:=xlGuess, _ OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom will only go down to the last row the autofilter is displaying. (ie. say if row 10 is the last row in my table, and is filtered out, the selection will only go down to row 9) Any ideas how to select all of my table whilst the autofiler is on?? Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sort data whilst autofiler is on
It does not matter whether you select the entire table or not. With an
autofilter on Excel will sort only the visible rows. You will have to remove the filter, sort and re-apply the filter. -- Jim "bony_tony" wrote in message oups.com... | Hi, | I would like to sort all of my data whilst the autofiler is on. I | currently have to clear the autofilter to select all the data, as... | | Range("A5:P" & Cells(Rows.Count, "A").End(xlUp).Row).Select | Selection.Sort Key1:=Range("C6"), Order1:=xlAscending, | Header:=xlGuess, _ | OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom | | will only go down to the last row the autofilter is displaying. (ie. | say if row 10 is the last row in my table, and is filtered out, the | selection will only go down to row 9) | | Any ideas how to select all of my table whilst the autofiler is on?? | | Thanks | |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Moving data from one worksheet to another whilst removing the data | Excel Discussion (Misc queries) | |||
How to hide blank rows after data whilst leaving some blanks. | New Users to Excel | |||
Autofiler issue | Excel Discussion (Misc queries) | |||
Protect Autofiler Column | Excel Discussion (Misc queries) | |||
autofiler disabled | Excel Discussion (Misc queries) |