LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27
Default Help in Keeping Cell at Active Cell

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Row select mode to highlight active row of active cell Bart Fay[_2_] Excel Discussion (Misc queries) 0 May 11th 10 09:34 PM
referring to formula in a non active cell from active cell nickname Excel Discussion (Misc queries) 1 June 21st 07 12:11 PM
how to merge many cell to one cell with keeping all data Valley Excel Worksheet Functions 0 August 25th 06 01:12 PM
find text in a cell and make cell 2 cells below that active shark102 Excel Programming 4 October 20th 05 02:41 PM
adding a cell to a cell keeping a running total please help RELWOD85[_5_] Excel Programming 1 August 3rd 05 08:31 AM


All times are GMT +1. The time now is 12:54 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"