run time error 1004 range of object _worksheet failed

Hi all,

Using Excel 2010.
The array, "aInput" is a vector: 1 column by 100K rows
The debug.print is printing a space first, then 100000 - which seems a little od an me be a tell as to why I am receiving the error message

The code below, debugs on the "Set" line
Any ideas?

thx
w

Please Login or Register  to view this content.

What is the variable declaration of rngOutputDescriptions?

Hi goss,

No, you cannot have a space when setting a range. See if this line of code solves the issue:

Please Login or Register  to view this content.

Regards,

Robert

Array dimensions are always type Long so CLng(UBound(aInput)) servers no purpose.
The space preceeding numbers debug printed is reserved for the minus sign. It's simply debug's output formatting and is not a part of the number.
What is the With statement that .Range is tied to?

There's nothing wrong with: .Range("A1:A" & lRowsOuput)

But it must be a part of a With..End With block:

Please Login or Register  to view this content.

But you did not show the entire code so we don't know if that dot-range statement is dangling by itself....

Thanks guys,

I looked at it for many hours off and on and never saw the spelling typo - until this morning (lRowsOutput / lRowsOuput)

Please Login or Register  to view this content.

thx
w