Can someone tell me how to copy and paste a range that has been
autofiltered, without selecting it?

--
Gordon Rainsford

London UK

John Coleman wrote:

Greetings,
I tend to regard .Select as the goto of Excel VBA: it is seldom
necessary and makes code harder to read, not to mention slower.
Nevertheless, I do sometimes use it - but (if I am honest) only in
cases where I do not really understand the object model (which in my
case includes things like PasteSpecial and Sort) and thus rely on
editing code from the macro recorder. Is it *ever* necessary to select
a range before performing some operation involving it? Just curious.

Have a good day

-John Coleman