Forum Discussion
An extremely odd bug in Excel 64 bit. Causing huge problems
rpbenzI have two other laptops with an I3 that complete this code in less than .15 seconds:
' For I = 0 To 180
' Sheet1.Cells(3 + I, 21) = Sheet2.Cells(k + I, 2).Value & ":"
' Next I
Yet my new I7takes over 6 seconds to do this same code. The same phenomena is happening with another laptop with an I5. Why?????
Just a week ago they were doing the same code no problems. There was an update to excel but they all have the same build now. I don't get whats going on? Ive virus checked and now am doing a code rewrite for the screwed up computers using range command but I am worried using Excel might be screwed up
Stay away from Excel Version 1907 (Build 11901.20218). This version totally screwed up my VBA application, causing weird behavior such as incredibly long times when simply writing to cells via a for-next loop:
' For I = 0 To 180
' Sheet1.Cells(3 + I, 21) = Sheet2.Cells(k + I, 2).Value & ":"
' Next I
I spent a good week trying to figure out why the code locked up on one computer but not the other and only resolved the problem by rolling back to Version 1905. I thought that Microsoft had their act together but apparently they're still having problems with their work.