R
rvik
i have a worksheet which contains 2 columns
on entering "X" in a1, the current local system time is automaticall
entered in a2 with the code
If Target.Column = 2 Then
Target.Offset(0, 1).Value = Now - Date
i have shared the file on a network, and would now want a standard tim
to be entered in a2.. i.e . i want the server time or my system tim
(where the file is located) entered in a
on entering "X" in a1, the current local system time is automaticall
entered in a2 with the code
If Target.Column = 2 Then
Target.Offset(0, 1).Value = Now - Date
i have shared the file on a network, and would now want a standard tim
to be entered in a2.. i.e . i want the server time or my system tim
(where the file is located) entered in a