Hi all,
I am trying to figure out why something is not working out for me.
I am using the following code to insert an array formula within the specified range.
It works, except the the last A1 (which I have left as a relative reference) is not actually changing as you go down the rows...(i.e. the formula is exactly the same in the whole range)... I would expect it to change to A2, A3, A4, etc....
with this folllowing code which is not an array formula, it works as expected....is it something to do with array formulas... do I need to reference the cells differently?
EDIT:
Is it perhaps because I am starting this formula in row 3 and since it references A1, it is confused somehow?
Bookmarks