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. Subsum_of fines() last row = Range("A10000") . End (xp). Row Subsum_of fines() last_row = Range("A10000"). End (x) Up ). Row For current_row = last_row To 4 Step 1 If Cells(current_row, 1) Value = "NYPD" Or. Cells(current_row, 1) . Value = "DOT" Then total_fine = total_fine + Cells(current_row, 4) Value End If Next Cells(last_row + 2, 3). Value = "The SUM of fines is" Cells(last_row +2,6 ). Value = total_fine Cells(last_row +2,6). Style = "Currency" End Sub End Sub 860 210 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. Subsum_of fines() last row = Range("A10000") . End (xp). Row Subsum_of fines() last_row = Range("A10000"). End (x) Up ). Row For current_row = last_row To 4 Step 1 If Cells(current_row, 1) Value = "NYPD" Or. Cells(current_row, 1) . Value = "DOT" Then total_fine = total_fine + Cells(current_row, 4) Value End If Next Cells(last_row + 2, 3). Value = "The SUM of fines is" Cells(last_row +2,6 ). Value = total_fine Cells(last_row +2,6). Style = "Currency" End Sub End Sub 860 210
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
