Rewrite the subroutine in exercise 1 so that it deals correctly with the end of the series.

Question:

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:

image

Suppose you want to turn this into:

image

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.

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

Financial Modeling

ISBN: 9780262027281

4th Edition

Authors: Simon Benninga

Question Posted: