Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello,
I have recorded a macro where in a time is entered in a cell. After entering the time the cursor gets back to cell D2.......I want after entering the time cursor should be at the same cell where time is entered. I have attached the text of recorded macro below........please suggest me the change that is required do get the result. Sub Macro2() ' ' Macro2 Macro ' Macro recorded 2/1/2006 by Dhami' ' Keyboard Shortcut: Ctrl+q ActiveCell.FormulaR1C1 = "=NOW()" Range("C:D").Select Selection.Copy Selection.PasteSpecial Paste:=xlPasteValuesAndNumberFormats, Operation:= _ xlNone, SkipBlanks:=False, Transpose:=False Range("D2").Select Application.CutCopyMode = False End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Row select mode to highlight active row of active cell | Excel Discussion (Misc queries) | |||
referring to formula in a non active cell from active cell | Excel Discussion (Misc queries) | |||
how to merge many cell to one cell with keeping all data | Excel Worksheet Functions | |||
find text in a cell and make cell 2 cells below that active | Excel Programming | |||
adding a cell to a cell keeping a running total please help | Excel Programming |