Forum Discussion

Copper Contributor

Aug 14, 2019

An extremely odd bug in Excel 64 bit. Causing huge problems

I have an Excel screen that is populated with images that refer to cell values. In addition, I have columns of data that are populated with tag names in another sheet of the same workbook. I have 4...

rpbenz

Copper Contributor

Aug 15, 2019

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

rpbenz
Copper Contributor
Aug 17, 2019
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.