Vba formula issues

I'm trying to create some vba code for a cell in my spreadsheet. I've used the same one with a basic "sum" but with a more complex formula it doesnt work:

Please Login or Register  to view this content.

Any ideas where I am going wrong?

Many thanks
Kasperblue

Hi,

When creating formula with VBA, any literal characters themselves need to be included in a pair of literal quote marks.

So use """" instead of just ""