VBA 'Cells.Value' no longer returns visible value in cell?

[bfishertarget]

Good Morning-

I have a simple excel macro which is triggered by the worksheet_change event. The macro is coded like this:

For q = 2 To 600
If Worksheets("Threshold Tracker").Cells(q, 1).Value = "" Then
Worksheets("Threshold Tracker").Cells(q, 1).Value = Input1
Worksheets("Threshold Tracker").Cells(q, 2).Value = Date
Worksheets("Threshold Tracker").Cells(q, 3).Value = Time
q = 600
End If
Next q

2 days ago this code worked great, today I open the file and the code will run but no values are showing up in the "Threshold Tracker" cells?? Could there be some setting that adjusted itself?

Thanks in advance,

-B

 

[bfishertarget]

All-

I have figured out my problem. It was a user error. I greatly appreciate all of your help.

Apologies,

-B