Need help with Application.WorksheetFunction
You haven't selected anything (except a worksheet) so don't use 'With
Selection' it's simpler than that
Sub standard()
Worksheets(1).Select
Range("B21").Value = Application.WorksheetFunction.Sum(Range("B17: B20"))
Range("C21").Value = Application.WorksheetFunction.Sum(Range("C17:C20") )
Range("D21").Value = Application.WorksheetFunction.Sum(Range("D17:D20") )
Range("F21").Value = Application.WorksheetFunction.Sum(Range("F17:F20") )
End Sub
Mike
"Ayo" wrote:
Worksheets(1).Select
With Selection
.Range("B21").Value = Application.WorksheetFunction.Sum("B17:B20")
.Range("C21").Value = Application.WorksheetFunction.Sum("C17:C20")
.Range("D21").Value = Application.WorksheetFunction.Sum("D17:D20")
.Range("F21").Value = Application.WorksheetFunction.Sum("F17:F20")
End With
What am I doing wrong here. I keep getting an error on this line
.Range("B21").Value = Application.WorksheetFunction.Sum("B17:B20").
I also get an error on ":" when I tried
.Range("B21").Value = Application.WorksheetFunction.Sum(B17:B20)
|