I am using a macro where I filter first, then copy and paste special (selecting paste values) into another sheet. This has been working fine for me so far, but now when I have large files with alot of data (eg. 100k cells), the copy paste function does not work correctly ( it does not paste correctly... it pastes the wrong information for some reason...). Does anyone know if this is because of some limitation of copy and paste? and how I can solve this problem?