Dave and Patrick,
Thanks very much for your responses. However, my macro is still no
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 the {F2} ke
from the macro to the WorkSheet (as opposed to opening the Objec
Browser)?

Patrick, I like your approach because it does not require insertion o
the Row number of the cell adjacent above the sum formula in a cel
away from the range to be summed. But I get an "Application-Defined o
object-defined error" message when using your Target.FormulaR1C1
"=SUM(R3C:R[-1]C".

Dave, I am using the row 4 rows down from the sum formula to displa
the row number of the cell adjacent above the sum formula (the Activ
Cell). In your ActiveCell.Formula, the compiler is having difficult
with the .Offset.
I would appreciate your continuing help.
Chuckles123

P.S.: A related issue is the ability to name a variable-length colum
or row in a macro. Any thoughts

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