I have a worksheet that pulls data from multiple worksheets using array formulas. I want to be able to limit the amount calculating this will do by replacing the formulas with the resulting values. First I want to look at column I to determine if there is an array/formula and start with the first row with one and use column Q to determine where to end when there are say 5 blank cells in a row. I was going to have this macro run upon opening the file and before calculating began. Any help would be appreciated. The range of values to copy and replace are columns I:O.