Getting worksheet.function.sum to reference correctly

[sagain2k]

I'm trying to sum up a range that is selected using an offset variable...tried this:

ActiveCell.Value = Application.WorksheetFunction.Sum(ActiveCell.Offset(0, -ColCalcNum).Address & ":" & ActiveCell.Offset(0, -1).Address)

Can't quite get the correct Syntax for this, or for the "Activecell.Formula = ..." method. Any suggestions?

 

[Ivan F Moala]

The help file is incorrect
You will need to use an object range for this

eg
<pre/>
Dim MyRg as Range

Set MyRg = Range(ActiveCell.Offset(0, -ColCalcNum).Address & ":" & ActiveCell.Offset(0, -1).Address)
ActiveCell.Value = Application.WorksheetFunction.Sum(MyRg)
MsgBox ActiveCell.Value

</pre>