Easy question: macro to move cursor one to the right

  • Thread starter Thread starter Sean Sydor
  • Start date Start date
S

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
 
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 **
 
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"
Click to expand...
ActiveCell.offset(0,1).Select

--
regards,
Tom Ogilvy



Sean Sydor said:
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
Click to expand...
 
Back
Top