Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to move to next cell
Trying to get a macro to move like I am using the arrow
keys left, right etc. with a number to left or right etc. Ex. ActiveCell.Activate.toRight = 3 Thanks Neil |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to move to next cell
Neil, will this help
Sub Move_Right() 'this will move 3 cells to the right ActiveCell.Offset(0, 3).Select End Sub Sub Move_Left() 'this will move 3 cells to the left ActiveCell.Offset(0, -3).Select End Sub -- Paul B Always backup your data before trying something new Using Excel 2000 & 97 Please post any response to the newsgroups so others can benefit from it ** remove news from my email address to reply by email ** "Neil" wrote in message ... Trying to get a macro to move like I am using the arrow keys left, right etc. with a number to left or right etc. Ex. ActiveCell.Activate.toRight = 3 Thanks Neil |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to move to next cell
"Neil" wrote in message ...
Trying to get a macro to move like I am using the arrow keys left, right etc. with a number to left or right etc. Ex. ActiveCell.Activate.toRight = 3 Thanks Neil Hi Neil, try, activecell.offset(0,1).select This should move the selected cell one column to the right... If you want to move it 3 column then use: activecell.offset(0,3).select where (0,3) is 0 rows, 3 columns hpoe this helps.... seeya ste |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Move cell contents with macro | Excel Discussion (Misc queries) | |||
macro to move to another cell | New Users to Excel | |||
macro to move cursor one cell right | New Users to Excel | |||
Macro to move one cell down | Excel Worksheet Functions | |||
macro to move part of cell contents to another cell | Excel Discussion (Misc queries) |