View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Fred Smith[_4_] Fred Smith[_4_] is offline
external usenet poster
 
Posts: 2,389
Default Using Advanced Filter: How do you MOVE the selected rows...

There's no built in Move function, so just delete the selected rows after
the copy.

Regards,
Fred

"ravif" wrote in message
...
I can copy the selected rows to another location, but is there a way to
move
the selected rows, so that the original sheet has only the unselected
rows?
I don't mind using VBA to program the modified behavior, if the Advanced
Filter has a documented programmable interface.