ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   CAN YOU CREATE A PATHWAY OF CELLS LIKE A PROGRAM (https://www.excelbanter.com/excel-programming/357396-can-you-create-pathway-cells-like-program.html)

Dean Costa

CAN YOU CREATE A PATHWAY OF CELLS LIKE A PROGRAM
 


funkymonkUK[_131_]

CAN YOU CREATE A PATHWAY OF CELLS LIKE A PROGRAM
 

Dean Costa Wrote:

Well first off....

If you explain a bit more maybe you will get more answers and maybe
more people will look at it than tryign to do a one liner in the suject
field.


second of all.... could you explain it..


--
funkymonkUK
------------------------------------------------------------------------
funkymonkUK's Profile: http://www.excelforum.com/member.php...o&userid=18135
View this thread: http://www.excelforum.com/showthread...hreadid=527304


Tom Ogilvy

CAN YOU CREATE A PATHWAY OF CELLS LIKE A PROGRAM
 
Select the cells in the order you want to traverse them (clickk on a cell,
then hold down the ctrl key while clicking the remaining cells in sequence).
then use the tab key or return key to nagivate through them.

To store it, with the cells selected, go to Insert=Name=Define

and enter a name in the Name field. Then click Add.

when you want it selected, select the name from the name box dropdown or hit
F5, select the name and click OK.

--
Regards,
Tom Ogilvy


"funkymonkUK" wrote:


Dean Costa Wrote:

Well first off....

If you explain a bit more maybe you will get more answers and maybe
more people will look at it than tryign to do a one liner in the suject
field.


second of all.... could you explain it..


--
funkymonkUK
------------------------------------------------------------------------
funkymonkUK's Profile: http://www.excelforum.com/member.php...o&userid=18135
View this thread: http://www.excelforum.com/showthread...hreadid=527304




All times are GMT +1. The time now is 02:46 PM.

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