inserting formula array with macro

[Pasha81]

Hi guys I'm trying to use macro to insert an array formula but it gives me syntax error
Any idea what may be wrong with the 2nd and 4th range here
thanks

Please Login or Register  to view this content.

[DonkeyOte]

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

Once tags are added we can tell you why you're experiencing difficulties...

[Pasha81]

Please Login or Register  to view this content.

here it is, sorry abt that...
any suggestions anyone?

[DonkeyOte]

If you need a literal quotation in VBA then double quote

Please Login or Register  to view this content.