Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sort filtered rows in VBA
Is it possible using VBA to sort only the visible rows
after a filter has been applied? I have tried and get a message saying the command (ie.Sort) cannot be run with multiple selections. For me it would be so much more efficient to sort after filtering, rather then the other way round. Any help would be greatly appreciated, as would a straight "No" answer! Thanks Rosemary |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sort filtered rows in VBA
select the whole filter range (not just visible rows) or select only a
single cell in the data. Worked fine for me. Only the visible rows were sorted. -- Regards, Tom Ogilvy "RW" wrote in message ... Is it possible using VBA to sort only the visible rows after a filter has been applied? I have tried and get a message saying the command (ie.Sort) cannot be run with multiple selections. For me it would be so much more efficient to sort after filtering, rather then the other way round. Any help would be greatly appreciated, as would a straight "No" answer! Thanks Rosemary |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sort filtered rows in VBA
Thanks Tom. This works fine for me too.
-----Original Message----- select the whole filter range (not just visible rows) or select only a single cell in the data. Worked fine for me. Only the visible rows were sorted. -- Regards, Tom Ogilvy "RW" wrote in message ... Is it possible using VBA to sort only the visible rows after a filter has been applied? I have tried and get a message saying the command (ie.Sort) cannot be run with multiple selections. For me it would be so much more efficient to sort after filtering, rather then the other way round. Any help would be greatly appreciated, as would a straight "No" answer! Thanks Rosemary . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Filtered Sort freezing up | Excel Discussion (Misc queries) | |||
Cut filtered rows, paste into next empty row of new sheet, and delete cut rows | Excel Worksheet Functions | |||
Help!! I have problem deleting 2500 rows of filtered rows!!!! | Excel Discussion (Misc queries) | |||
How sort filtered file. | New Users to Excel | |||
Filtered Visible Rows & VBA Non-Filtered Rows Displayed | Excel Programming |