Rewrite the subroutine in exercise 1 so that it deals correctly with the end of the series. One possible treatment is not to ask to repeat the process when the last cell in the series is dealt with.

Rewrite exercise 1

Suppose you have a spreadsheet with a series of numbers and formulas:

Suppose you want to turn this into:

Write a subroutine that does this. Your subroutine should:

? Put in a set of parentheses and multiply the cell contents by 100.

? Move down one cell (see ActiveCellDemo1 , section 39.1).

? Ask if you want to repeat the process (if ?yes,? it should do it; if ?no,? the subroutine should exit).

The parentheses have to come after the ? = .? The Right function might be used for this operation.

You may want to refer to section 39.2 for more information on the MsgBox function and the values it returns.

Transcribed Image Text:

A EX1 Run Sub 2 3 Price Return 1000.00 1069.45 1158.53 1213.49 5 0.069451061 <- =A5/A4-1 0.083296895 <- =A6/A5-1 6 7 0.047440948 <-m =A7/A6-1 0.046204665 <- =A8/A7-1 8 1269. 56 9 1287.02 0.013745727 <-- =A9/A8-1 0.022788538 <- =A10/A9-1 0.01195957 -A11/A10-1 10 1316.34 1332.09 11