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.png


Img 2:

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



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


Thanks,
Kamal
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

using excel vba ope a word doc and copy-paste into another word doc 0
COPY PASTE VALUES ONLY FROM/ON VISIBLE CELLS 6
Copy visible cells after filtered paste to first empty cell 1
Copy Visible Cells and paste in another workbook visible cells only 5
select only used rows and only visible cells 2
Pasting to visible cells only? 1
Paste to Visible Cells only 1
Alternate Column Shading to be applied only to visible columns 6

Top