VBA Copy and Paste with filter

The following code works well except if the table is filtered. any ideas on how to get around that without undoing the filtering?

Please Login or Register  to view this content.

What is the goal? (1) Copy all from one column to another or (2) copy visible cells (filtered) in one column to another?

Of course normal copy visible cells and paste, pastes with not invisible rows. This is usually a good thing.

Attach a short example file if you like.

Yes, i just want to copy "old" column to "new" column regardless of filtering. I need the old column to be an exact clone of the new as we are comparing results day by day.