Can an array formula be included in VBA code?

[Aland2929]

I want to include the following array formula in my code but get an object defined error?

Please Login or Register  to view this content.

Thanks in advance

[AndyLitch]

Please Login or Register  to view this content.

[Aland2929]

Thanks Andy but the AT3 part of the formula remains absolute and it needs to be relative?

[AndyLitch]

The only thing i can think of then is to write the formula to AV3 and paste it down the column ??

[Aland2929]

This is the code I am trying to use but is not working?

Please Login or Register  to view this content.

Thanks in advance

[Aland2929]

I am getting an error on the 2nd row??

Please Login or Register  to view this content.

[Aland2929]

The error message is :Method range of Object Global failed

Thanks in advance

[Aland2929]

I think the problem is with the Paste part of the code but I can't figure it out? Would appreciate some help.
Thanks in advance

[AndyLitch]

Try this

Please Login or Register  to view this content.

[Aland2929]

Thanks for your response Andy. I get the following error message relating to the last line of code:

[Object does not support this property or method]

Thanks in advance

[Aland2929]

I would appreciate any help with this as I have not been able to resolve it.

Thanks in advance