View Single Post
  #2   Report Post  
Bernie Deitrick
 
Posts: n/a
Default

Amododa,

You cannot cut/paste multiple area selections. So, you need to copy/paste,
and then go back to your filtered list and use Edit / Go To... / Special /
Visible Cells only, then delete.

HTH,
Bernie
MS Excel MVP

"Amadoda" wrote in message
...
If I copy/paste from an auto-filtered sheet I copy/paste only the

highlighted
rows. If I CUT/paste, I cut and paste all the intermediate cells hidden

by
the auto-filter. I don't want that! (Note: in the paste sheet the
intermediate cells are hidden until I [FORMAY/ROW/UNHIDE]. Also once you
de-select back to ALL [UNDO] is not available!