moving cursor

P

PECOSBOB

Is there a way I can get the cursor to move by using an "IF" function.
e.g. =if(m5=1,goto"a5",x). I know goto isn't a command but is there one to
move the cusor? I do not want to incorporate it into a macro.
 
D

Don Guillett

Formulas ONLY return values. You would need a macro. However, you usually
don't need to goto a cell to work with it.
 

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

Similar Threads

Oversensitive touchpad on modern laptops 0
Copying Conditional formating in a List of text and values. 14
how to display my cursor cell content in another cell.... 6
cursor goto a5 in Sheet1 but 1
Moving cusor around spread sheet 7
Using a macro to enter a formula 4
Automatically moving from one cell to another 3
set cursor on a control 1

Top