Create a macro (or function) to jump cells

[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

 

[matt]

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

Michael,

I would start by looking up the following items in the Visual Basic
Editor:

GoTo Method
Select Case Statement
If...Then...Else Statement
Offset Property
ActiveCell Property

Matt