Syntax error

[shelim481]

Hi,
When copy the following direct into excel i dont get any errors, works perfectly but if i put it into a module and run it, i get syntax error...

=average(INDIRECT($A2&"!a:a"))*SUM(INDIRECT($A2&"!B:B"))+1

But VBA it doesnt not allow me, what am i doing wrong?

Range("E2").Formula = "=average(INDIRECT($A2&"!a:a"))*SUM(INDIRECT($A2&"!B:B"))+1"

 

[Fluff]

You need to double up on the " inside the formula, like
$A2&""!a:a""

 

[shelim481]

Fantastic, thank you...

 

[Fluff]

You're welcome & thanks for the feedback