Array VBA question

[matt4003]

All,

I am trying to get my Array Formula in a Macro, so the user can just hit a button and the formula is pasted into the cell and turned into an array.

Please Login or Register  to view this content.

I am able to get the formula into the cell with the macro, but not turn it into an array. The above does not work.

Thoughts?

Cheers
Matt

[Leith Ross]

Hello Matt,

What happens when you execute the macro? Do you get an error message?

[matt4003]

Hi Leith,

Yes, an error:

"Run-time error '1004':
Unable to set the FormulaArray property of the Range class"

Thoughts?

Matt

[Leith Ross]

Hello Matt,

Try doing this way without selecting the cell.

Please Login or Register  to view this content.

[matt4003]

Hello Leith,

I tried that. Same error.

I have a hard time imagining that it is the problem, but could it be that this is an excel 97-2003 file that I am working on in excel 2010?

Cheers,
Matt

[Leith Ross]

Hello Matt,

The FormulaArray property is limited to 255 characters. Your string is 290 characters.

[matt4003]

Sorry for the delay Leith, I have been in the process of relocating to Europe from the US.

Your solution was perfect!

Thanks,
Matt