Microsoft Excel VBA sum function not working

Question

When i run the code i want the answer of the sum to be displayed in the cell (F 27).

But the sum function does not work nothing is printed into the cells when i run the code. I don't get any errors what so ever.

This is my code

Private Sub TextTotal1_Functions()

Dim SumTotal As Long

SumTotal = WorksheetFunction.Sum(Range("F9:F26"))

Range("F27") = SumTotal

Thanks for your help!

Your code works for me without issue. Try your code in a new workbook and see if it works. — Scott Craner
– Scott Craner, Commented Oct 19, 2016 at 13:38

Preston · Accepted Answer · 2016-10-19 15:05:50Z

1

My guess is that you're not specifying the sheet correctly, try the below

Private Sub TextTotal1_Functions()

Dim SumTotal As Long

SumTotal = Application.WorksheetFunction.Sum(Sheets("MySheetNameHere").Range("F9:F26"))

Sheets("MySheetNameHere").Range("F27") = SumTotal

edited Oct 19, 2016 at 15:05

answered Oct 19, 2016 at 13:40

Preston

8,26511 gold badges64 silver badges96 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

PartyHatPanda Over a year ago

if you are fully qualifying ranges, you might want to qualify the final range (last line) as well. Sheets("MySheetNameHere").Range("F27") = SumTotal

Vityata · Accepted Answer · 2016-10-19 13:50:34Z

0

What I usually do when I use WorksheetFunction in VBA, is to write something like this in the immediate window:

?WorksheetFunction.Sum(selection)

and to see whether I am getting what I am expecting from the selection.

answered Oct 19, 2016 at 13:50

Vityata

43.8k10 gold badges64 silver badges110 bronze badges

Comments

vich · Accepted Answer · 2017-09-26 18:51:12Z

0

Might be the Calculation is set to Manual, so set it back to Automatic:

Application.calcualtion = xlCalculationAutomatic

edited Sep 26, 2017 at 18:51

vich

11.9k13 gold badges52 silver badges67 bronze badges

answered Sep 26, 2017 at 18:45

Tauseef

1

Collectives™ on Stack Overflow

Microsoft Excel VBA sum function not working

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related