I am having a problem with this script.
Private Sub Worksheet_Change(ByVal Target As Range)
Dim rng As Range
Dim c As Range
Set rng = Columns(4)
If Intersect(Target, rng) Is Nothing Or Target.Count > 1 Then Exit Sub
Target.Offset(0, -1) = Time
Target.Offset(0, -2) = Date
Set c = rng.Find(Target, After:=Target, lookat:=xlPart, searchorder:=xlByRows, searchdirection:=xlPrevious)
If Not c Is Nothing And c.Address Target.Address Then Target.Offset(0, 3) = _
Target.Offset(0, -1) - c.Offset(0, -1)
If you like these VB formatting tags please consider sponsoring the author in support of injured Royal Marines
The script is supposed to check column D (Lift truck # column) and find any values that match and then subtract the log
times of the left adjacent C column cells next to the matching numbers in D column and print the diffennce in column G beside
the right bottom most matching number in D.
As you can see the script is seeing "1450" as "50" and displaying the
difference when the two numbers don't actually match. The script is seing the "50" that is in the "1450".
sure there is a quick and easy solution, but I an not experienced enough to know what it is..
Thanks for the help!