Hi All,

I got struck in middle of my code and I am in need from your guys. my query is below.

I have filter some criteria from 3 different column and I have almost 25 columns and I want only 4 columns, I can copy data by selecting only visible cells, however due to my system internal issue when ever I am trying to copy excel automating not responding and get close. so I thought to apply Range property something like this.

however below code reflecting only starting rows which is not hidden rest all its not taking. hence any one can I assist to get this done.

Note: Sorry I cant post the sample file due to sensitive data and permissing.

Please Login or Register  to view this content.