| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Strange results...
With the following in my sheet1 - let's say I copy cell B4 - with contents Dog
and paste into A100. A100 only shows Dog and from my immediate window if I then do ? application.enableevents (r) I get False <<< Why? Private Sub Worksheet_Change(ByVal Target As Range) Application.EnableEvents = False If Not Application.Intersect(Range("A:A"), Target) Is Nothing Then _ Target.Value = Target.Value & "-" & Date Application.EnableEvents = True End Sub |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Strange results...
Never mind; I got it going..
"Jim May" wrote: With the following in my sheet1 - let's say I copy cell B4 - with contents Dog and paste into A100. A100 only shows Dog and from my immediate window if I then do ? application.enableevents (r) I get False <<< Why? Private Sub Worksheet_Change(ByVal Target As Range) Application.EnableEvents = False If Not Application.Intersect(Range("A:A"), Target) Is Nothing Then _ Target.Value = Target.Value & "-" & Date Application.EnableEvents = True End Sub |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| GET.CHART.ITEM returning strange results | Charts and Charting in Excel | |||
| Database Functions - Strange results | Excel Worksheet Functions | |||
| Strange Log base 10 results | Excel Programming | |||
| Strange Results with Autofilter | Excel Discussion (Misc queries) | |||
| Strange results using .FIND in Excel VBA | Excel Programming | |||
Linear Mode
