| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| does an array contain contents of cell | New Users to Excel | |||
| #N/A if cell contents not part of an array | Excel Discussion (Misc queries) | |||
| Compare row contents w/Sumproduct or Array formula? | Excel Worksheet Functions | |||
| How do I concatenate the contents of an array in Excel? | Excel Worksheet Functions | |||
| Randomize the order of the contents of an array | Excel Programming | |||
![Dave[_15_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
