4. A puzzle. The last thing you are going to do is get a little bit more practic

Question

4. A puzzle. The last thing you are going to do is get a little bit more practice with working with flowcharts and writing VBA code. The code presented below is incomplete and the flowchart on the following page is also incomplete but the flowchart corresponds to the code below Function WhatDoIDo (DataRange) Dim nRows As Integer, nCols As Integer Dim i As Integer, j As Integer, MaxVal As Double Dimx As Double = DataRange . Rows . Count B | = DataRange . Columns. Count axval = Application . WorksheetFunction . Max (DataRange) x = DataRange (1, 1) If MaxVal = x Then x = DataRange (1, 2) For i = 1 To For j = 1 To D If DataRange (i, j) MaxVal Then If DataRange (i, j) x Then x = DataRange (i, j) End If End If Next j Next E

Explanation / Answer

In the above the PSEUDO CODE the MISSING VALUES are:-

A------> nRows

B----->nCols

C------>nRows

D------->nCols

E-------->i

F-------->x

in FLOW CHART missing values:-

G--------->i

H-------->1

I----------->nRows

J----------->j

K----------->1

L----------->nCols

M--------->DataRange(i,j)<>MaxValue

N--------->DataRange(i,j)>MaxValue

Related Questions

Navigate

• Browse (All)
• Browse 4
• Subjects

---