Thread: Is it possible to increase Excel's availible memory?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Anya[_2_] Anya[_2_] is offline
external usenet poster
  
Posts: 6
Default 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

Reply With QuoteReply With Quote