Create a macro (or function) to jump cells

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
 
M

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top