Need a Concatenating VBA code to prevent memory issue workaround
- by doharr
My set up:
Have 50,000 rows of data.  ( My row count will increase in the future. So might as well say I have a full worksheet of 64000+ rows.)
All Data is TEXT, no formulas, etc. 
Column A is open 
Columns B thru AC contain the Data that needs to be concatenated 
The Data in the rows once concatenated to Column A will contain 60,000 digits or 6kb in file size. After additional maniuplation each cell will become a file.
I have tried concatenating in Excel and I run into memory issues. The memory issue is when I Select and fill down the concatenating function into the worksheet. It crashes at the 8200 +/-row. 
My system is 2gb of ram, windows xp professional and Excel 2003. Have 4GB of disk space 
Hoping to find a VBA code that will conserve memory, and not crash like it does in excel. 
Thank you