Using Advanced Filter: How do you MOVE the selected rows...

  • Thread starter Thread starter ravif
  • Start date Start date
R

ravif

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.
 
There's no built in Move function, so just delete the selected rows after
the copy.

Regards,
Fred
 
Fred,
Thanks for your reply, and I think before I delete, I have to choose the
visible rows, as given in a previous post.
Thanks again.
--ravif
 
You're right. You just select the same rows you are copying (the visible
ones).

Regards,
Fred.
 
Back
Top