How to copy visible cells only?

[mso3]

Hi friends,
I want to copy only visible cells to get correct output. In the following code I’m not getting correct output because of it in the attached file.

Any help will be appreciated.

Thanking you,

[:) Sixthsense :)]

Replace this line

Please Login or Register  to view this content.

With

Please Login or Register  to view this content.

[nilem]

or maybe so

Please Login or Register  to view this content.

[mso3]

Hi Sixthsense and Nilem,
Thank you.

Sixthsense still it's not giving correct output because of auto filter is on after copying the data.

Nilem the code is working absolutely fine as per my requirement.

I appreciate both of you for your kind cooperation to solve my problems continuously.

Thank you and have a nice day.

[mso3]

Hi Nilem,
First of all I apologize for posting my query here a solved thread.
The code is working fine for English remarks but not working properly for devanagari remarks. Actually it’s working fine but only last entry is repeating.

Please see the attached file and suggest me a solution to avoide this problem.

I have inserted the numbers in column ‘J’ percentage to check whether the sorting is working properly or not. It’s working fine because all the numbers in column ‘J’ percentage are in a serial order, only last entry is repeating.

Waiting to get a solution to solve this problem.

Sorry once again for trouble.

Thanking you,

[nilem]

Hi mso3,
try so

Please Login or Register  to view this content.

[mso3]

Hello Nilem,
Excellent solution. Now it's working absolutely fine as per requirement.

Thank you very much for your guidance.