column Q contains a formula that gives in cells a value and after 5 minutes the value disappears
i use this code for auto copy paste from Q:Q to V:V
Private Sub Worksheet_Change(ByVal Target As Range)    
  If Not Intersect(Target, [Q1]) Is Nothing Then        
  [v1:V100] = [q1:q100].Value     
 End If  End Sub
but when a blank cell in Q take a value, not copied in V ,and sometimes not copied either the existing values.
why that happens? i want to copied when a cell in Q take a value because after 5 min the value disappears.
must correct something in my code?