absolute references that are relative

  • I have a subroutine that uses the sumifs function. The final argument - R137C- is a an absolute reference to a date so I can autofill down the column with each cell referencing R137C. However, if I insert a row somewhere above R137C I need my code to reference R138C because everything shifted down. How do I do this?

    "=SumIfs(PunchList.xlsx!C12, PunchList.xlsx!C4, RC1, PunchList.xlsx!C8,R137C)"

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!