rollingzep
Board Regular
- Joined
- Nov 18, 2013
- Messages
- 214
- Office Version
- 365
- Platform
- Windows
Hi All,
At work, I use a large workbook of 30kb. My workplace has the MS office 32-bit version.
The issue is, in my VBA code, when i try to delete columns using ws.range("AS":"BA"). delete, I run into memory issues and space shortage errors.
This code is at the very end of the module.
But when I comment this line, I have no issues at all. The module executes perfectly.
But I need to delete these columns as a part of clean up.
I am currently manually deleting them after all data has been imported and the report is generated.
Is there a workaround?
TIA.
At work, I use a large workbook of 30kb. My workplace has the MS office 32-bit version.
The issue is, in my VBA code, when i try to delete columns using ws.range("AS":"BA"). delete, I run into memory issues and space shortage errors.
This code is at the very end of the module.
But when I comment this line, I have no issues at all. The module executes perfectly.
But I need to delete these columns as a part of clean up.
I am currently manually deleting them after all data has been imported and the report is generated.
Is there a workaround?
TIA.