Range setFormulaLocal doesn't work

[Nils_Junker]

Hi,

can somebody tell me why this code doesn't work?

I get the following problem:

Thanks for your help!

 

[Georgiboy]

Have you tried it without the backslash before the "\GEN"?

So instead of ,\"\GEN" try ,"\GEN"

 

[Nils_Junker]

Have you tried it without the backslash before the "\GEN"?

So instead of ,\"\GEN" try ,"\GEN"

it does work if i do it like that:

the only problem i now got is that the are C3:C177 not fixed is.
Do you now how i can fix cells in VBA so that even when i pull the data to the right C3:C177 stays?

 

[Georgiboy]

Try using: $C:$3:$C$177