hi
Ctrl+G -> select Visible Cell Only -> and copy this will work

Punnam