good day all...i have been toying with a formula for a bit and have not gotten anywhere. i have a named range, a placeholder really, in cell A2. now, in cell A5, there is another named range. i need a formula that will COUNTA between those two ranges, not including the ranges themselves. the kicker here is, that data is inserted after the last row via vba so the 2nd named range in A5...will change, to A6 or to A7, etc. however the named range doesn't change. that is why i need this formula.

i have tried =counta(test1:test2) but of course that would have been too easy

thank you for any help!