Posts by marus_b

    Hello all,

    I'm trying to substitute a static range in a function with a dynamic one, and I cannot seem to get it right.

    Essentially, I have the following function in one of my cells:


    I would love to be able to substitute the MATCH function ranges for an actual function as follows:


    < to be substituted by the following which essentially gives me the same result, except it's not static >

    ADDRESS(CELL("row",ServiceFeesHdrs)+1,CELL("col",ServiceFeesHdrs)) &":"& ADDRESS(CELL("row",ServiceFeesHdrs)+ROWS(ServiceFeesHdrs)-1,CELL("col",ServiceFeesHdrs))

    The address function gives me precisely the same result as the static range address.

    Any help would be greatly appreciated.