Hi there,

This procedure works fine when I step through with F8, but it crashes Excel when I try to run it. I have simplified the macro for the purposes of posting it. It is intended to create a new workbook with a sheet called "Facility Prep Detail," and a folder on the user's desktop to save it to. It should copy an existing "Facility" sheet from the blank template to the new book. Then, it should filter data in another workbook and copy the visible data only to the Facility Prep Detail sheet in the new book. Finally it should save the file to the new folder and display a message saying that this has been done.

The data set that is being filtered (named range "PrepRawData") is very large so my only guess is that this is the cause. I understand that Special Cells has been known for its size limitation but that this was fixed for Excel 2010, which I am using. None of this explains why the macro works great iteratively. I know parts of it could be cleaner but I just want to get it running.

Thank you in advance!

Please Login or Register  to view this content.