Copy visible cells to other worksheet

[etaver87]

Hi everyone,

I'm trying to copy only visible cells from one worksheet to another and am using the following code for this:

Please Login or Register  to view this content.

Unfortunately, I get a run-time error 1004 - PasteSpecial method of Range class failed when executing the macro with the button in the sheet "Import".

Can someone help me to find out what I'm doing wrong? You can find the Workbook here:

https://www.dropbox.com/s/w739aecyyo...PORT.xlsm?dl=0

[Faridwahidi]

Hi etaver87,

You may try this.
If the code helped you, please add reputation me "*"

Please Login or Register  to view this content.

[etaver87]

It works only partially. It doesn't copy the values (I get only 0's) and links aren't copied either.

[Faridwahidi]

hi,

maybe this?

Please Login or Register  to view this content.