Issue with formula within VBA

[McQLon]

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

[xlnitwit]

You should be using Formula and not FormulaR1C1 since you are are not using R1C1 addressing

ActiveCell.Formula = "=SUM('CUST_AR001:CUST_ZA009'!G:G)/2-SUM('Raw data'!X:X)"

[McQLon]

Excellent, thank you