Question: QUESTION 2 On the following VBA Code the yellow part, represent what? Sub IfStatement 4 ( ) - Example of nested If's. Dim cell As
QUESTION
On the following VBA Code the yellow part, represent what?
Sub IfStatement
Example of nested If's.
Dim cell As Range
Const cutoff
Go down Employee column. If all scores for a Employee are greater
Than cutoff, boldface the Employee number. Note the indenting.
It is crucial for readability!
For Each cell In wsData.RanaeEmolovee
If cell. Offset Value cutoff Then
If cell.Offset Value cutoff Then
If cell.Offset Value cutoff Then cell. Font.Bold True
End If
End If
End If
Next
End Sub
A straitght logic structure
A nested if Structure using else
A nested Loop structure
A nested if structure without else
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
