formula from VBA not working

[Nils_Junker]

Hi everybody,

my VBA looks like this:
i.e.: table1Sheet.range("D221").Formula2 = "=INDIREKT(ADRESSE(193,VERGLEICH(Dashboard!$P$17,Tabelle1!D2:BD2,0)+3))"
now this brings up the error #NAME
(Formula2 because of the @ which would be added without it)

But if I put the formula in the sheet manually it works.
What is the problem here?
Thanks for your help!

 

[Fluff]

Did you try the line of code I supplied?

 

[Nils_Junker]

Did you try the line of code I supplied?

yes it is not working

 

[Fluff]

In what way?

 

[Nils_Junker]

In what way?

VBA doesn't let me put ";" in the code

 

[Fluff]

What actually happens when you try the line I suggested?

 

[Nils_Junker]

What actually happens when you try the line I suggested?

 

[Fluff]

That's odd, the whole point of formula2local is to use your local settings & language.
Try the two suggestions made by Alex in post#9

 

[Nils_Junker]

That's odd, the whole point of formula2local is to use your local settings & language.
Try the two suggestions made by Alex in post#9

i saw that I forgot to add the Local i tried it before with local but without the ";"
now it works, thank you very much!

 

[Fluff]

Glad we could help & thanks for the feedback.