VBA: How to troubleshoot 'Out of Memory' scenarios when processing large datasets in Excel?
I'm attempting to set up I'm working with an 'Out of Memory' behavior while running a VBA macro that processes large datasets in Excel. The macro is intended to loop through a table of approximately 100,000 rows and perform calculations based on certain conditions. I've tried optimizing my code by using `Option Explicit`, but the behavior keeps occurring. My code snippet looks like this: ```vba Sub ProcessData() Dim ws As Worksheet Dim lastRow As Long Dim i As Long Set ws = ThisWorkbook.Sheets("Data") lastRow = ws.Cells(ws.Rows.Count, "A").End(xlUp).Row For i = 2 To lastRow ' Do some calculations If ws.Cells(i, "B").Value > 100 Then ws.Cells(i, "C").Value = ws.Cells(i, "B").Value * 2 End If Next i End Sub ``` I've also tried adjusting my Excel settings to increase the allocated memory, but it doesn't seem to help. The macro runs fine on smaller datasets (around 10,000 rows), but it crashes as soon as I increase the data size. I suspect that my variable declarations or array usage might be inefficient, but I'm not sure how to improve them. Any guidance on how to resolve this scenario would be greatly appreciated!