I am hoping this is simple but I haven't sussed it yet :(

I have a cell selected through a macro which searches and selects on a
specific term

This works fine. I want the active cell to be one to the right of the
active cell. (Next collumn) Is this easily done with one line?

Thanks if anyone can provide a solution for me

rngFound.Offset(0,1).activate

wrote in message
ups.com...
I am hoping this is simple but I haven't sussed it yet :(

I have a cell selected through a macro which searches and selects on a
specific term

This works fine. I want the active cell to be one to the right of the
active cell. (Next collumn) Is this easily done with one line?

Thanks if anyone can provide a solution for me

Thanks guys :)

Good of you too help! :)
Martin Fishlock wrote:

Hi,

This moves you to the cell to the right of your active cell (and down to
column 1 of the next row if at the end of the current row)

Sub nextcell()
If ActiveCell.Column < Cells.Columns.Count Then
ActiveCell.Offset(0, 1).Activate
'optional for next row if at end
ElseIf ActiveCell.Row < Cells.Rows.Count Then
Cells(ActiveCell.Row + 1, 1).Activate
End If
End Sub

--
Hope this helps
Martin Fishlock, Bangkok, Thailand
Please do not forget to rate this reply.


" wrote:

I am hoping this is simple but I haven't sussed it yet :(

I have a cell selected through a macro which searches and selects on a
specific term

This works fine. I want the active cell to be one to the right of the
active cell. (Next collumn) Is this easily done with one line?

Thanks if anyone can provide a solution for me