Selecting Cells
Try selection.offset(1,0).select
or activecell.offset(1,0).select
or range("B1").select
or [b1].select
or .offset(1,0). means 1 cell down
or .offset(0,1). means 1 cell right
or .offset(-1,0). means 1 cell up
or .offset(0,-1). means 1 cell left
"Gabe" wrote in message
...
Hey,
I'm trying to select the next cell down, just like you would if you used
the
up and down keys on your keyboard. What code could I use?
I tried this already but it doesn't work:
Range("B3").Activate
ActiveCell.Next(x1Down).Select
Any suggestions?
|