Question: The following Excel image has a VBA program (see below). What will be the result after the program is exccuted? Anycells not displayed are currently
The following Excel image has a VBA program (see below). What will be the result after the program is exccuted? Anycells not displayed are currently empty, and any cells with numbers are formatted numeric. Sub AFD0 Tot =0 LastRow = Cells(Rows Count, 1). Endixlup). Row LastRow - LastRow - 1 For 1 - LastRow To 9 Step 1 If Cells(i, 3) Value = "BELLS" Then Rows(i). Delete Eise Tot - Tot + Cells (i,5). Value End If Next 1 Msebox "The final result is & Tot, "2200 Endsib 13 12 14 The proigram is incorrect - will not run 15
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
