Rewrite the subroutine in exercise 3 so that its action is dependent on the cells contents.

Question:

Rewrite the subroutine in exercise 3 so that its action is dependent on the cell’s contents.

• If the cell contents is a formula, it will be replaced by the same formula multiplied by 2.

• If the cell contents is a number, it will be replaced by a number equal to the old number multiplied by 2.

• On all other cells in the current region, nothing will be done.


To make life easier, you may assume, for the purposes of this exercise, that a formula is anything beginning with “ = ” and a number is anything beginning with the characters “0” to “9.”

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: