View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Dave[_15_] Dave[_15_] is offline
external usenet poster
 
Posts: 11
Default Dumping the contents of a VBA array to a sheet

I've got a VBA array that is 65536 rows by 2 columns (I've truncated it to
fit into two columns) that I'm trying to dump to the A and B columns of a
spreadsheet. I'm getting a Runtime 1004 error a few seconds after the line
of code tries to execute the dump

Presumably I'm trying to dump too much data, if so how do I dump the array
in smaller chunks?

Cheers

Dave