View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Sean Sydor Sean Sydor is offline
external usenet poster
 
Posts: 1
Default 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