Easy question: macro to move cursor one to the right

[Sean Sydor]

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

 

[Paul B]

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 **

 

[Tom Ogilvy]

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

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