Pages Generated by macro are slow

I work at a landscape architecture firm, and was tasked with updating our office master plant list. I used the following code to generate and save individual plantlists, and it works! but it's incredibly slow. the files that is generates (which have no code on them) are extremely slow and i don't have the slightest clue why. it takes nearly 10 seconds to update any of the fields in the generated workbook. does anyone have an idea as to why this happens and how it can be resolved?

Please Login or Register  to view this content.

sorry, here's the rest of the code

Please Login or Register  to view this content.