VBA Array Formula

[hobbiton73]

Hi, I wonder whether someone may be able to help me please.

I'm uising the code below to try and apply, amongst other functionality a formula to a given cell, but I'm having difficulty in applying the formula.

Please Login or Register  to view this content.

This is the line of code I'm having difficulty which I've put togther from posts I've read on this and other forums:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Manually entered, the formula works fine, but when I run this I receive the following error:

Run time error '1004' Unable to set the FormulaArray property of the Range Class

I just wondered whether someone could look at this please and let me know where I've gone wrong.

Many thanks and kind regards

[JBeaucaire]

Try just removing the word Selection, leave that period after it...

[JosephP]

you've gotta double all the quotes too

Please Login or Register  to view this content.

[hobbiton73]

Hi @Joseph, thank you very much for taking the time to reply to my post and for the code revision. In conjunction with the guidance from @JBeaucaire, this now works perfectly.

All the best and kind regards