Thread
:
Shift cursor to the cell on the right
View Single Post
#
9
Don Guillett
Posts: n/a
Surely there is a better way than typing it in. Perhaps if you give us more
info we can help more.
--
Don Guillett
SalesAid Software
"Steved" wrote in message
...
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.
-----Original Message-----
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.
.
.
Reply With Quote