Help with time formula so the time will not change.
You can do it with a Change event:
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 3 Then 'column C
Range("B" & Target.Row) = Now
End If
End Sub
Do you know how to install it?
Regards,
Stefi
€˛Joker€¯ ezt Ć*rta:
I am in need of help with a formula involving the time. What I need is for
the time to automatically fill in a cell when info is typed into another cell
and to not change. I have the formula =IF(C480,NOW(),"") in cell B48. It
will display the time when I enter info into cell C48, the problem is that
the time keeps changing as I make other changes to the worksheet. Is there
any way I can prevent the time from changing from the original time? Thank
you for your help.
|