Excel 2007 -> Excel 2003 : FormulaArray issue

[Astrid]

Hi,

I am having a problem with a FormulaArray:

Please Login or Register  to view this content.

I used some code I did a couple of years back with Excel 2007 to come up the code above but I can't make it work.
I get the error 438 saying the property or method is not handled by the object??

As I am working with Excel 2003 now I wonder if it might be that my syntax is wrong for Excel 2003?

Any guesses?

Cheers!

[sweep]

Hi,

I'm not entirely sure, but I don't think 2003 will handle whole columns in an array....

Try...

Please Login or Register  to view this content.

[Astrid]

Hi,

Thanks for answering!
That's not the issue, I already tried something like that (and just tried your code as well) but the bug is in the following line, with the FormulaArray.

[Roger Govier]

Hi,

I'm not entirely sure, but I don't think 2003 will handle whole columns in an array....

Try...

Please Login or Register  to view this content.

Hi
I think that will still return the whole column as the range

I would be inclined to use

Please Login or Register  to view this content.

or use Rows.count -1

[Astrid]

My bad, the "s" is missing on Cells... Sorry about that!