ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   moving cursor (https://www.excelbanter.com/excel-worksheet-functions/216847-moving-cursor.html)

PECOSBOB

moving cursor
 
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.


Don Guillett

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"PECOSBOB" wrote in message
...
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.




All times are GMT +1. The time now is 03:30 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com