Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Move the active cell
Dear Sirs,
Can someone help to write a Macro to move the active cell to my designated location, not by cell reference. But go to somewhere by direction and distance. Example: The active cell is B1, but it is variable. I need the active cell to go to the next cell in its right hand side, it means C1. Or from C1 to D1, Or from C3 to C4. Is it possible? Can someone help? -- Dennis Cheung |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Move the active cell
Hello
ActiveCell.Offset(0,1).Select HTH Cordially Pascal "Dennis Cheung" a écrit dans le message de news: ... Dear Sirs, Can someone help to write a Macro to move the active cell to my designated location, not by cell reference. But go to somewhere by direction and distance. Example: The active cell is B1, but it is variable. I need the active cell to go to the next cell in its right hand side, it means C1. Or from C1 to D1, Or from C3 to C4. Is it possible? Can someone help? -- Dennis Cheung |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Move the active cell
Hi Dennis,
If your intention is to select the next cell in the current row programmatically, Papou has suggested the required code. If, however, your intention is to select the next cell in the current row in response to the Enter key, try: Menu | Tools | Options | Edit | Move selection after Enter | Right --- Regards, Norman "Dennis Cheung" wrote in message ... Dear Sirs, Can someone help to write a Macro to move the active cell to my designated location, not by cell reference. But go to somewhere by direction and distance. Example: The active cell is B1, but it is variable. I need the active cell to go to the next cell in its right hand side, it means C1. Or from C1 to D1, Or from C3 to C4. Is it possible? Can someone help? -- Dennis Cheung |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
move from active cell offset in macro | Excel Discussion (Misc queries) | |||
Move active cell to same location on each worksheet | Excel Discussion (Misc queries) | |||
move within ss by active cell position, NOT by cell names | Excel Programming | |||
accept input and move active cell? | Excel Programming | |||
need to Copy or Move to active cell from specified range | Excel Discussion (Misc queries) |