i have this big excel file........and its taking a long time to run.......i found (through this site asking questions) that the cause of my program taking a long time to run is the calculations/formulas autocalculating...........so i am removing those formulas in my file that are not needed and in their place i am using arrays to calculate the values. I am then putting the values in the cells instead of the formulas.