Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Transfer from Excel to array and back to Excel
Thanks for the help. My data files can be pretty large; 20,000 rows by 40 or so columns so it can take a few hours to process the data without using arrays. (If it didn't crash) After sitting on a offshore oil platform and searching through some books I've finally come up with a faster...- rotary
- Post #4
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Transfer from Excel to array and back to Excel
I've been trying to transfer a large amount of data from Excel to an array for processing and then back to Excel. I can do this by looping line by line but I haven't been able to move the data in a single step. Can the data be moved in a single step? If so, any hints on how it should be...- rotary
- Thread
- Replies: 3
- Forum: VBA Visual Basic for Applications (Microsoft)
