ActiveCell.Formula = "=SUM(A" & x & ":A" & y ")"

Which is absolute with respect to the location of the cell where you will
place the formula. If you want relative to that cell, I think you would
need to calculate the values for x and y so you can do it absolute - in
other words, excel won't do the adjustment for you.

--
Regards,
Tom Ogilvy


"David Fixemer" wrote in message
...
Tom,

Thanks for the info. How would the aforementioned
formula look in "A1 notation"?

David