ExcelBanter - Is it possible to increase Excel's availible memory?

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Is it possible to increase Excel's availible memory? (https://www.excelbanter.com/excel-programming/303491-possible-increase-excels-availible-memory.html)

Anya[_2_]

Is it possible to increase Excel's availible memory?

Could you copy the worksheets one by one?
Sub CopySheets()

Dim i As Integer

For i = 1 To ThisWorkbook.Sheets.Count
ThisWorkbook.Sheets(i).Copy After:=Workbooks
("Book1").Sheets(1)
Next i

End Sub

All times are GMT +1. The time now is 05:29 PM.