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

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

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