Question: The following Excel image has a VBA program (see below). What will be the result after the program is executed? Any cells not displayed are

The following Excel image has a VBA program (see below). What will be the result after the program is executed? Any cells not displayed are currently empty, and any cells with numbers are formatted numeric. The following Excel image has a VBA program (see below). What will

Sub TWS()
a = 0
i = 15
Do While i >= 13
a = a + Cells(i - 6, 2).Value
i = i - 1
Loop
MsgBox A, , "The Total "
End Sub

10

0

20

30

The program is incorrect-will not run

A B C D 1 Total Widgets Sold (TWS) - 1st Quarter 2 3 Name January February March 4 Abe 10 100 1,000 5 Bells 10 100 1,000 6 Charles 10 100 1,000 7 8 David 10 100 1,000 9 Frank 10 100 1,000 10 11 Harold 10 100 1,000 12 lan 10 100 1,000 13 Jared 10 100 1,000 14 Lila 10 100 1,000 15 Matthew 10 100 1,000 16 Total 100 1,000 10,000

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!