Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Shift cursor to the cell on the right
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. |
#2
|
|||
|
|||
ActiveCell.Offset(0,1).Select
"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. |
#3
|
|||
|
|||
Thankyou very Much.
Cheers -----Original Message----- ActiveCell.Offset(0,1).Select "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. . |
#4
|
|||
|
|||
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. |
#5
|
|||
|
|||
ActiveCell.Offset(0,1).Select
Gord Dibben Excel MVP On Mon, 29 Nov 2004 14:00:55 -0800, "Steved" wrote: 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. |
#6
|
|||
|
|||
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. . |
#8
|
|||
|
|||
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. . . |
#9
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do you delete a cell then shift cell up? | Excel Discussion (Misc queries) | |||
Addition to Turn cell red if today is greater or equal to date in cell | New Users to Excel | |||
GET.CELL | Excel Worksheet Functions | |||
Cell Shift | Excel Worksheet Functions | |||
VLookup resulting in a blank cell... | Excel Worksheet Functions |