Thread: Selecting Cells
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Gene Mills Gene  Mills is offline
external usenet poster
 
Posts: 6
Default 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?