Inserting formula using vba is adding unwanted brackets

**strud** · 02-06-2014, 07:30 AM

I am adding in a formula using the following code:

Please Login or Register  to view this content.

When it enters the formula, though, it is adding an unnecessary brackets so that the formula does not work (highlighted in bold).

Formula:

Please Login or Register  to view this content.

Any ideas why it is doing this and what I can do to stop it?

Thanks

**buran** · 02-06-2014, 07:36 AM

You mix R1C1 and A1 style in the formula. Use only R1C1 style

**Olly** · 02-06-2014, 07:40 AM

You need to use R1C1 references, if you're using .formulaR1C1...

So the formula would become:

Please Login or Register  to view this content.

**strud** · 02-06-2014, 07:45 AM

Awesome, cheers guys!

Re: Inserting formula using vba is adding unwanted brackets