Selection.Value = ARRAY Limit?

S

Serena595

Hi folks,

I'm at a loss and I'm hoping someone could help.

Dim IA_Array(659, 229) As Variant
'In the code - I load this array with values

ActiveSheet.Range("E11:IQ660").Select
Selection.Value = IALead_Array

Sometimes VBA correctly pastes the entire contents of the array into the
selected range. Most of the time, it pastes #N/A in the last few columns -
(it always begins with column IA).

In the debugger the IALead_Array(15,223) has a value (it isn't #N/A) - does
Excel have a limit here?

Thanks!

BTW: Excel 2003 and I have 1 GB of RAM
 
Top