How to copy and paste only visible cells from Excel using vbscript

K

Kamal_Chennai

Joined
Apr 6, 2017
Messages
1
Reaction score
0
Hi,

I want to copy only visible cells by using vbs. not vba. In Img 1 Country column is hidden but while pasting the visible cell from sheet1 to sheet2 its showing country column.

Selection.SpecialCells(xlCellTypeVisible).Select

This code is not working in vbs.


Img 1:

upload_2017-4-6_16-43-36.webp


Img 2:

upload_2017-4-6_17-35-24.webp



Please let me know if there is any alternate way to do that.


Thanks,
Kamal
 
Back
Top