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?
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?