Hi,

I have added the below code to a file and it isn't quite working for some reason. Can anyone help?

Once the macro has run, the formula entered looks like this in the relevant cell in Excel, if there isn't a set of brackets around the last x then the formula would work fine but i can determine why the brackets are appearing:-

=SUM(CUST_AR001:CUST_ZA009!G:g)/2-SUM('Raw data'!x: (x))

The code I have used is as follows:

Sheets("run macro").Select
Range("b13").Select
ActiveCell.FormulaR1C1 = _
"=SUM(CUST_AR001:CUST_ZA009!G:G)/2-SUM('Raw data'!X:X)"
Range("b13").Select


Thanks,
McQLon