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!
|