Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
cursor keys in a macro
I recorded a macro and modified it and part of it works great, al
except for the last step. Here is what I'm trying to do. I need to put the current time in a cell and a little while later pu the time in the cell to the right. Kind of like a timer. I recorded a macro that put the function Now() in the cell, then copy to clipboard, then paste special (values) back in the same cell. this puts the time back in the cell where its won't recalculate as th function NOW(). I modified the macro to use the Active.cell whe pasting so it won't jump to the cell I recorded macro with. that par works great. The problem is with the last step... After I paste the first time int the cell, I want to move one cell to the right. the recorded macr puts in the cell I use during recording... I need that to be relative I need to modify to just cursor I think I need the macro command to cursor once to the right. the current macro is... ' ' ActiveCell.FormulaR1C1 = "=NOW()" ActiveCell.Select Selection.Copy Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone SkipBlanks _ :=False, Transpose:=False End Sub What do I add to just move to the right one column? Thanks Mar -- Message posted from http://www.ExcelForum.com |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Arrow keys won't move cursor | Excel Discussion (Misc queries) | |||
Cursor Movement with Arrow Keys | Excel Discussion (Misc queries) | |||
Cursor keys moving page??? | Excel Discussion (Misc queries) | |||
Cursor keys moving page??? | Setting up and Configuration of Excel | |||
cursor disappears using arrow keys | Excel Discussion (Misc queries) |