Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excessive Rows In 2007 to 2003 | Excel Discussion (Misc queries) | |||
Simple Macro | Excel Worksheet Functions | |||
question about excessive code in replacing #N/A when using VLOOKUP | Excel Discussion (Misc queries) | |||
Simple macro help | Excel Discussion (Misc queries) | |||
excessive rows when scrolling down | Excel Worksheet Functions |