LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,101
Default excessive calcs for simple macro . . .

I am using the simple code below to insert a timestamp into column 2 adjacent
to an entry in column one. The macro code works, but Excel needlessly
calculates for about 30 seconds after it has placed the timestamp. My
colleague took the code to his workstation and claimed it worked narmally
there. We compared Excels settings on the two machines and found nothing
obvious.

Might anyone have a clue why it does this and how I might stop it? (or
another way to code to get the same effect?)

Private Sub Worksheet_Change(ByVal Target As Range)
Select Case Selection.Column
Case 1
Cells(Target.Row, 2).Value = Now

End Select

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
Excessive Rows In 2007 to 2003 FARAZ QURESHI Excel Discussion (Misc queries) 2 February 6th 08 11:39 AM
Simple Macro John Excel Worksheet Functions 1 November 17th 06 05:16 PM
question about excessive code in replacing #N/A when using VLOOKUP njuneardave Excel Discussion (Misc queries) 4 June 21st 06 03:14 AM
Simple macro help chip_pyp Excel Discussion (Misc queries) 3 January 10th 06 07:57 PM
excessive rows when scrolling down Chantel Excel Worksheet Functions 1 March 18th 05 05:01 PM


All times are GMT +1. The time now is 01:04 AM.

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"