is it possible to use a variable as an argument to a
function? for example: rng1.formula = "=sum(rng2)". im
trying to write a macro that places the sum formula in the
worksheet just below the data. i dont know how many rows
of data there is, so I cant hard code the sum range.