Move 2 cells to right

[Guest]

hi,
Please help.
In excel vba, what is the command to move the cursor.
Example: The cursor was in one cell and i want move it 2 cells to the left.

Thanks in advance.

 

[Bob Phillips]

Activecell.Offset(0,2).Select

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Guest]

Sub Macro1()
Dim i As Long
Dim j As Long
j = Selection.Column
i = Selection.Row
Cells(i, j + 2).Select
End Sub

to move to an arbitrary place use
Cells(I+9,J+13).Select for example

 

[Guest]

You rarely need to select a cell or range of cells in VBA. Code is cleaner
and works FAR faster if you do not select cells.

To answer you question, though

activecell.offset(0,-2).select

Now, if you are selecting it because you want to copy it, or clear it, etc,
do this instead

activecell.offset(0,-2).copy
activecell.offset(0,-2).clear
activecell.offset(0,-2).pastespecial xlPasteAll

 

[Guest]

Hi!
Thanks to all for your help about.

Regards.
Paulo