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
|