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.

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.

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.

Donna,

Seems to me there's a cleaner way, but this seems to work:

Cell1 = ActiveCell.Offset(1, 0).Address
Cell2 = ActiveCell.Offset(0, 1).Address
Range(Cell1 & "," & Cell2).Select

Or you can combine them, though it is harder to debug:
Range(ActiveCell.Offset(1, 0).Address & "," & ActiveCell.Offset(0,
1).Address).Select

Earl Kiosterud
www.smokeylake.com

"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.