Macro taking too long to execute

Greetings all

I have been working on a macro this week that will insert a row underneath the header and write the formulas to the proper cells so that we can record production in a reasonably efficient manner. I do not claim to be a macro magician and I am sure there are better ways to accomplish some of the things I am doing, but it seem as though this particular macro has taken it upon itself to run too slow to be useful at all. The entire macro, comments and all is only 266 lines long (and there are a lot of comments as I wanted someone else to be able to go in a tell what was going on). It seemed to be working fine yesterday and I have been putting the final formulas in today before working on the formatting. When I tested it before lunch, it froze, so after lunch I ran it in debug mode and it isn't hanging on the back end where I have been working today, but at the very beginning. Can someone please take a look at this and see if there is something I am missing that would cause it to hang up?

Please Login or Register  to view this content.

Right now, I have data going out to column BP and a little over 3,100 rows

I would appreciate it if anyone could see what I am doing that would cause this thing to hang up like it is.

Thanks

Thanks for your response!

I tried it, but without any success. It still took about 4 minutes to execute the macro. One thing I noticed while watching the screen not do anything, was that the program would alternate between being responsive and not responsive. I wasn't trying to do anything else at the time, just watching. I took out the screenupdating statements and tried again and it still alternated between responsive and non responsive.

When I insert the row

Please Login or Register  to view this content.

Actually, the file Product Data is almost always already open, so it seldom has to actually open it. It isn't making any sense to me either.