| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Moving to another cell
I am setting this spreadsheet up for our operators I need something tha takes no thought from there sid -- mporter50 ----------------------------------------------------------------------- mporter501's Profile: http://www.excelforum.com/member.php...nfo&userid=767 View this thread: http://www.excelforum.com/showthread.php?threadid=26617 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Moving to another cell
Only first approach:
Range("A1:A6,B6,C7,D8").Select Range("A1").Activate ActiveWorkbook.Names.Add Name:="test", RefersToR1C1:= _ "=Sheet1!R1C1,Sheet1!R1C1,Sheet1!R2C1,Sheet1!R3C1, Sheet1!R4C1,Sheet1!R5C1,Sh eet1!R6C1,Sheet1!R6C2,Sheet1!R7C3,Sheet1!R8C4" Application.Goto Reference:="test" Jorge "mporter501" escreveu na mensagem ... I am setting this spreadsheet up for our operators I need something that takes no thought from there side -- mporter501 ------------------------------------------------------------------------ mporter501's Profile: http://www.excelforum.com/member.php...fo&userid=7677 View this thread: http://www.excelforum.com/showthread...hreadid=266176 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Arrow keys moving whole excel sprdsht insted of from cell to cell | New Users to Excel | |||
| Arrow keys move screen instead of moving from cell to cell | Excel Discussion (Misc queries) | |||
| Moving cell contents to new cell loses background color in old cel | Excel Discussion (Misc queries) | |||
| Arrow keys move screen instead of moving from cell to cell. | Setting up and Configuration of Excel | |||
| How to copy formatting when moving from cell to variable to another cell on another worksheet | Excel Programming | |||
![mporter501[_7_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
