[Resolved] Excel is hitting a speed bump

[brellis1]

When I first open my database and run it my macro it takes about a minute to run. If I try to rerun this Macro it takes 15 minutes. If I close the Workbook and open it back up it only takes 1 minute again. I am using large Static Arrays, but I use the Erase command to erase these Arrays. Does anyone have any idea why there would be this much slowdown?

[RobDog888]

Not very easy to determine without seeing the code and knowing what its doing.

[brellis1]

I think I solved it. My problem was I wasn't turning the screen updating off and then on.
Application.ScreenUpdating = False
code
Application.ScreenUpdating = True
Thanks for the help

[RobDog888]

But ScreenUpdating is a performance saver. Were you clicking the button multiple times during the initial macro run or ?

[brellis1]

No I was just running my macro like usual (1 click). The problem was it was trying to always update the text on screen. When I implemented that the screen didn't try to update till the end. Plus my biggest problem is I haven't gotten a handle on all the internal functions in VBA. I am sure their is a search function, but I could never find it and just used a for loop with my array. Thanks for your help

[RobDog888]

Oh I see. Yes there is a search function. Its called the Find method. Works off of a Range object. No looping and faster.