Copy Filtered Data on visible rows

Hello,

I have another problem I am not sure is possible to code around. I filter my list sometimes more than a million rows and filter out certain criteria. Then I want to copy just the visible data which is the filtered data and paste it into another sheet. The problem is the data is so large I keep getting errors. I tried to reduce the data size and address it in chunks of 100,000 lines and do it 10 times but it is insanely slow and there has to be a better way right? This is the code I am using...

Please Login or Register  to view this content.

I have updated with code tags and the code does work but it takes close to 10 mins to run, I was wondering if I am doing it a really slow way and if it could be faster?

Please Login or Register  to view this content.

Doesn't Work

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

I guess you're saying that the simple copy code doesn't work - can you:

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic