excel - Dynamic range in a formula array -

VBA newbie here I'm trying to use an array formula via Excel VBA but I can not seem to specify a dynamic range for the formula. I have:

  range ("xyz"). FormulaArere = "= some work (Data! RC: R [8] C [49])"

but next time it may be

  range ("Xyz"). FormulaAre = "= No work (data! RC: R [15] C [32])"

It does not seem to work, is there a solution?

If you mean a range from dynamic range whose size is determined by VBA variable (example For JRO and KCL) then

  range ("Exists"). FormulaRR1C1 = "= some work (Data! RC: R [" _ and seestrate (JRO) "and"] [[] and cstr (kCol) and "])"

If you are asking how many rows and columns are in a field, how it should be fixed

range. Current Region Range. Current and Range.ex (XLEEP). Xladown, XLRite, XLLEFT)

Layout