Easy question: macro to move cursor one to the right
Hi:
I have a macro that creates a new line in my spreadsheet and automatically calculates the input number in Row A. What I require to finish this macro is the code that will tell the macro to "tab" over one cell. I have tried a few ways but have been unsuccessful. Please help. Here is my code so far: Cells(Cells(Rows.Count, "A").End(xlUp).Row + 1, 1).Select ActiveCell.FormulaR1C1 = "=R[-1]C+1" Thank you, Sean |
Easy question: macro to move cursor one to the right
Sean, try this Cells(Cells(Rows.Count, "A").End(xlUp).Row + 1, 1).Offset(0,
1).Select -- Paul B Always backup your data before trying something new Using Excel 2000 & 97 Please post any response to the newsgroups so others can benefit from it ** remove news from my email address to reply by email ** "Sean Sydor" wrote in message ... Hi: I have a macro that creates a new line in my spreadsheet and automatically calculates the input number in Row A. What I require to finish this macro is the code that will tell the macro to "tab" over one cell. I have tried a few ways but have been unsuccessful. Please help. Here is my code so far: Cells(Cells(Rows.Count, "A").End(xlUp).Row + 1, 1).Select ActiveCell.FormulaR1C1 = "=R[-1]C+1" Thank you, Sean |
Easy question: macro to move cursor one to the right
do you want to move to the right after you enter the formula
Cells(Cells(Rows.Count, "A").End(xlUp).Row + 1, 1).Select ActiveCell.FormulaR1C1 = "=R[-1]C+1" ActiveCell.offset(0,1).Select -- regards, Tom Ogilvy Sean Sydor wrote in message ... Hi: I have a macro that creates a new line in my spreadsheet and automatically calculates the input number in Row A. What I require to finish this macro is the code that will tell the macro to "tab" over one cell. I have tried a few ways but have been unsuccessful. Please help. Here is my code so far: Cells(Cells(Rows.Count, "A").End(xlUp).Row + 1, 1).Select ActiveCell.FormulaR1C1 = "=R[-1]C+1" Thank you, Sean |
All times are GMT +1. The time now is 07:35 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com