Hello,

I have the following formula in a cell in my spreadsheet:
... which I want to automate in VBA.

I've tried:
but it doesn't work.

Am not sure how to translate from one to the other.

Thank you in advance for any help ...

Andy :)

try Every place you want a " to appear in the string that gets installed as the formula, use "". Just one doublequote [DQ] by itself ends the interpreter reading your typing as a literal string. Two DQs in a row are interpreted as one DQ in the string you are creating.

Understood - thank you :)