Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
move cursor in excle using macro | Excel Discussion (Misc queries) | |||
macro to move cursor one cell right | New Users to Excel | |||
move cursor on one sheet moves cursor on all sheets | Excel Discussion (Misc queries) | |||
Visual basic macro move cursor down 1 cell | Excel Worksheet Functions | |||
An easy macro question and one I believe to be a little more diffi | Excel Worksheet Functions |