hi, I have a macro in a worksheet that selects the last populated cell in a
range (D18:V18), copies the formula from this cell and pastes it into the
next empty cell to the right. I wish to then create a formula in cell Y18
that will sum only the range from the newly populated cell to the end of the
range (V18). this formula needs to update and use the newly populated cell as
it's starting point whenever the macro is run. am I asking too much from a
formula and need to use vba instead or is this possible?
thanks in advance

sevi