Dave and Patrick,
Thanks very much for your responses. However, my macro is stil
not working.
I appreciate the comment about mixing relative and absolute addressin
in my formula; but it appears to be a non-fatal error. I say thi
because I was able to get the formula = SUM(J3:J99) in the appropriat
cell, which, in the WorkSheet, by keying {F2} and {ENTER}, I was abl
to get the numerical result to display.
Which, part of my original question, is why can I not send th
{F2} key from the macro to the WorkSheet (as opposed to opening th
Object Browser)?
Patrick, I like your approach because it does not requir
insertion of the Row number of the cell adjacent above the sum formul
in a cell away from the range to be summed. But I get a
"Application-Defined or object-defined error" message when using you
Target.FormulaR1C1 = "=SUM(R3C:R[-1]C".
Dave, I am using the row 4 rows down from the sum formula t
display the row number of the cell adjacent above the sum formula (th
Active Cell). In your ActiveCell.Formula, the compiler is havin
difficulty with the .Offset.
I would appreciate your continuing help.
Chuckles12

--
Chuckles12
-----------------------------------------------------------------------
Chuckles123's Profile: http://www.excelforum.com/member.php...fo&userid=1494
View this thread: http://www.excelforum.com/showthread.php?threadid=26581