Quote Originally Posted by Zmcpherson View Post
I just tried using the ScreenUpdating property, I didnt see any increase in the over all speed of the code. That would of been awesome though, thanks for the thought.
I have not used ScreenUpdating in .NET automation but did with VB6 with Excel and did seem to make a difference. You might take a look at this thread where several post suggest using Application.calculation=xlManual before doing your code then application.Calculation=xlAutomatic when done (check out the next to last reply).