Hi All,

I am using a Macro which read the data from A1 Every 1 Min, and paste it A3, and next min pasted at A4. Its an increamental Macro.
I want to create a macro which also lock the date and time in B3 and respective cell. Whenever a cell filled through 1st macro it auto fill and lock the date and time in next column row.

Currently i am using the following macro.


Sub Macro1()
'
' Macro1 Macro
'
Static lngRow As Long
'
If lngRow = 0 Then
lngRow = 3
End If
Range("A" & lngRow).Value = Range("A1").Value
lngRow = lngRow + 1
Application.OnTime Now + TimeValue("00:01:00"), "Macro1", True
End Sub


Regards
Irfan