Snap shot of variable cells

[albatross32]

A1 is constantly variable with data being received automatically from an online source.

I would like in B2 to record the value of A1 at a specified instant in time without having any effect upon the continual variation of entries in A1.

Effectively, in laymans terms, I would like to be able to record "A1 @ 21:10:30 =".

The value of B2 would then remain fixed until either cancelled or the 'snap shot' macro/VBA re-run.

 

[mikerickson]

Sub SnapShot()
    Range("B2").Value = Range("A1").Value
End Sub

Or use the Macro Recorder.