View Single Post
  #2   Report Post  
Nick Hodge
 
Posts: n/a
Default select a cell and the one next to it

Donna

How about

Sub SelectOneBelowAndOneRight()
ActiveCell.Resize(1, 2).Offset(1, 0).Select
End Su

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS


"Donna S" wrote in message
...
I'm trying to select the cell below the one I'm in and the cell to the
right
of the one below where I am. I know how to select a cell below the cell
I'm
in by useing the ActiveCell.Offset(1,0).select but I don't know how to
select
the one to the right of it at the same time. Please help.