M
mrlanier
I hope someone has a solution for the following:
Cell A1 returns multiple values depending on a variety of conditions.
Each value returned will then create a condition causing the active
cell to jump to various cellss on the worksheet. For example, if
A1=1, the active cell might be programmed to jump to B10. If A1=2,
the active cell might jump to B15 and so forth. There could be as
many as 15 or 20 possible returns for A1. In the end, when A1=0, the
active cell must return to normal use.
Is there a relatively simple solution for this? Thanks in advance.
Michael
Cell A1 returns multiple values depending on a variety of conditions.
Each value returned will then create a condition causing the active
cell to jump to various cellss on the worksheet. For example, if
A1=1, the active cell might be programmed to jump to B10. If A1=2,
the active cell might jump to B15 and so forth. There could be as
many as 15 or 20 possible returns for A1. In the end, when A1=0, the
active cell must return to normal use.
Is there a relatively simple solution for this? Thanks in advance.
Michael