VBA Simple .Autofilter Copy Paste will not succeed?

[timpie]

Hello there,

I am overlooking something here but I just don't see it.
I am trying to autofilter data and copy it somewhere but it
always fails on paste??
I have 2 tests in the file ... tabblad Demo I copied somewhere from
the internet the second is my own creation and I can't seem to
reproduce the behaviour.

Excel in attachment.
Can you direct me in the right direction.

Ultimately I want to copy the second column from the autofilter results somewhere.
Is this possible? For example following statement:
Rng.Columns(2).Copy

[AB33]

This line is wrong
Application.CutCopyMode = False
it is deleting the copied cells.

Please Login or Register  to view this content.

[timpie]

I cannot believe it was this simple .... lost alot of time searching for this ... thankx alot!