-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
lrt
-
VBA: Excel crashes with a bigger amount of data
Hello everybody. I have a problem with one of my macro: with a bigger amount of data then usual, Excel crashes without reporting the type of error. https://imgur.com/a/gGkwECB I have isolated the part of the code which causes the matter, and it should be the following. In this case the...- Nelson78
- Thread
- amount application.calculation data end lrt
- Replies: 1
- Forum: Excel Questions
-
VBA: sudden crash during macro execution
Hello everybody. I'm managing a lot of data with a complex macro. At a certain point, Excel stops to work. The message is: Microsoft Excel has stopped working Windows is checking for a solution to a problem I have identified the part of code where the event happens. lrt = 4586, the event...- Nelson78
- Thread
- dim event excel lrt macro
- Replies: 4
- Forum: Excel Questions
-
VBA: just one loop instead of one for any check
Hello everybody. I have a macro that produces the right result. The aspect to improuve is in making it quicker: as you can see in this small part, I have a lot of checks to perform in any single cell. I suppose that checking everything in a single loop could reduce in a significant way the...- Nelson78
- Thread
- 3.value 6.value cell323 lrt sheetsrecord.rangebl2bn
- Replies: 3
- Forum: Excel Questions
