View Single Post
  #3   Report Post  
Gary''s Student
 
Posts: n/a
Default select a cell and the one next to it

Sub Macro()
i = Selection.Row
j = Selection.Column
Range(Cells(i + 1, j), Cells(i + 1, j + 1)).Select
End Sub

--
Gary's Student


"Donna S" wrote:

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.