Sort filtered rows in VBA

[RW]

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

 

[Tom Ogilvy]

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.

 

[RW]

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






.