Shift cursor to the cell on the right

[Steved]

Helo from Steved

Please what code to I put in the Macro to have the cursor
move to the next cell on the right.

Thankyou.

 

[Paulw2k]

ActiveCell.Offset(0,1).Select

 

[Steved]

Thankyou very Much.

Cheers

-----Original Message-----
ActiveCell.Offset(0,1).Select





.

 

[Don Guillett]

offset(0,1).select but WHY? It is almost never necessary to SELECT to get
the job done.
Post your code here for comments.

 

[Gord Dibben]

ActiveCell.Offset(0,1).Select

Gord Dibben Excel MVP

 

[Steved]

Hello Don from Steved

Let's say you have recorded a macro in cell K3

Sub Test3()
ActiveCell.FormulaR1C1 = "6-116-6"
Range("L3").Select
End Sub

Now I'm in cell K28 using the above macro it returns to L3
hence putting in offset(0,1).select and delete Range
("L3").Select solved my issue.

Cheers.

 

[Don Guillett]

I don't understand but this does your text and clears L3

activecell="6-116-6"
range("l3").clear

 

[Steved]

Hello Don from Steved

I am sorry I did'nt explain myself.
I should have given the reason for the cursor to goto the
right cell and that is that I needed to type in a decimal
time and I've got over 900 rows to do.

Sorry about that.

Cheers.

 

[Don Guillett]

Surely there is a better way than typing it in. Perhaps if you give us more
info we can help more.