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

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

--
Don Guillett
SalesAid Software

"Steved" wrote in message
...
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.




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

--
Don Guillett
SalesAid Software

"Steved" wrote in
message
...
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.


.