Copy/Paste Only Visible Cell AND Without Formatting

Hello,
VBA Question,
Just trying to figure out how to copy only the "Visible" cells from one sheet, and paste it to another, without the "Formatting"

Here's what I've tried, and keep getting error 400:

Attempt#1

Please Login or Register  to view this content.

Attempt#2

Please Login or Register  to view this content.

There's probably even a simpler way of doing this,

Any help would be appreciated,

Thanks,

Hi Aaeijh,
Attempt#1 works for me

thanks!, that worked.