VBA Excel if not executing all lines of code-CodePudding

Very simple basic code that I have done a million times before, why is it not working?

Sheet1.Range("S831") = "QWER"
Sheet1.Range("T831") = "3456"

With this code S831 now = QWER but T831 did not update to 3456. If I put in break points the code will stop at Sheet1.Range("S831") = "QWER" but it will not stop at Sheet1.Range("T831") = "3456"

CodePudding user response：

What if you try writing it a different way.

Worksheets("WorksheetName").range("S831").value = "QWER"
Worksheets("WorksheetName").range("T831").value = "3456"

CodePudding user response：

Today it is working, I made no changes...