Stephen Spittal
New Member
Good Morning All,
I was wondering if there is anyone who might be able to aid in helping me to speed up the running of my code in the attached file
The Code initilizes a number of Arrays and the mashes them together to give me one give report that i then use to generate a set of pivot tables (Separate module of code), each of the arrays fo minimum of 50,000 Rows. The current runtime of script is 7 hours which isnt productive enough from a work perspective.
I was wondering if there is anyone who might be able to aid in helping me to speed up the running of my code in the attached file
The Code initilizes a number of Arrays and the mashes them together to give me one give report that i then use to generate a set of pivot tables (Separate module of code), each of the arrays fo minimum of 50,000 Rows. The current runtime of script is 7 hours which isnt productive enough from a work perspective.