Need Help Speeding up my Macro.

Need some help speeding up my Macro. As of now it takes about 4-8 seconds to complete. I cant seem to figure out why its taking so long, I tried only copying and pasting one column only and still takes a while, Tried screwing around with the cell ranges to a smaller range and still takes a while.

The Sheet it is filtering and copying data from does have a lot of formulas in it, so maybe that could be why is taking so long? But it shouldnt matter should it, if I turn off auto calculate?

I have a similar macro for another filter table sheet and it loads almost instantly, only difference is the sheet its copying data from does not have so many formulas.

I read up that having your code make a bunch of trips to another worksheet to copy data from can slow it down, but I even tried the below macro with just making one trip to copy data and still took awhile to load.

Please Login or Register  to view this content.

Thanks,
Brent

Thanks gmr4evr1 for the suggestion.

I just tried it like you explained, but unfortunately it still ran the same amount of time.

Here is my excel file, probably should had uploaded this before.

It is too big to upload directly to this site so the below link will get you the file

https://www.dropbox.com/s/ww0hj7admb...acro.xlsm?dl=0

Originally Posted by gmr4evr1

The file is over 7MB. Can OP upload it here? I downloaded it from the dropbox link (which, btw, took several minutes) and tried to upload it here but it says that it failed. I tried it the way Trevor and Hans suggested, and another way that I always use since the "paperclip" option stopped working, and they both failed.

Yeah like I said before, its a large file and I wasnt able to load it to this site which is why i gave the dropbox link. Thanks for the help all for showing me how to upload though.

I will try and make some time making a demo version and upload it so it wont be so large.

Well I just answered my own question.

Turns out that when I pre-filled a bunch of formulas in a little over a 1000 rows by about 10 columns or so, for reasons I dont understand it slowed down my macro for filtering. I filled that many rows with formulas for anticipation while working in case that many rows were needed. I cut out about half those rows and the macro runs much faster like I was expecting. Guess for now ill just reduce the amount of rows that require formulas, then the user can just copy and past previous row with formulas to the new row if needed. But in all honesty, so far 500 rows were never all used, so I think 500 rows full of formulas is good enough.

Thanks for the help and sorry bout the attachment dilemma. Will rep those that I think helped me out.