Need help with Application.WorksheetFunction

[Ayo]

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("D1720")
.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)

 

[Gary''s Student]

Sub hfska()
Worksheets(1).Select
With Selection
..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("D1720"))
..Range("F21").Value = Application.WorksheetFunction.Sum(Range("F17:F20"))
End With
End Sub

In VBA SUM() needs a real range.

 

[Ayo]

Thanks Gary's student.
I will try that.

Sub hfska()
Worksheets(1).Select
With Selection
.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("D1720"))
.Range("F21").Value = Application.WorksheetFunction.Sum(Range("F17:F20"))
End With
End Sub

In VBA SUM() needs a real range.

 

[Mike H]

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("D1720"))
Range("F21").Value = Application.WorksheetFunction.Sum(Range("F17:F20"))
End Sub

Mike

 

[Don Guillett]

No selections. Notice the . before range in BOTH cases

Sub sumem()
With Worksheets("sheet11")
.Range("d1").Value = Application.Sum(.Range("c2:c22"))
End With
End Sub