I am using a insert rows macro which carries formulas when you insert a row. I have two relative formulas and one absolute formula. One of my relative formulas is =IF(D11=1, A11+1,""), whenever I add rows with my macro D11 and A11 stay the same. I need them to change for the next row.