Question: Select Cell H 3 using absolute referencing. b . If the value in the cell that is one cell to the left of the active
Select Cell H using absolute referencing.
b If the value in the cell that is one cell to the left of the active cell is greater than or equal to then A should be the value displayed in the current active cell. c If the value in the cell that is one cell to the left of the active cell is greater than or equal to then B should be the value displayed in the current active cell. d If the value in the cell that is one cell to the left of the active cell is greater than or equal to then C should be the value displayed in the current active cell. e If the value in the cell that is one cell to the left of the active cell is greater than or equal to then D should be the value displayed in the current active cell.
f Otherwise, the value displayed in the current active cell should be F g Move down one cell below the active cell using relative referencing. h Write this macro so steps b c d e and f will be performed over and over again
until the cell one cell to the left of the active cell is blank. Make sure the loop is written so the statements of code will be executed once before the condition is evaluated to determine if the code should be repeated
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
