deleting @

[Nils_Junker]

Hi everybody,

i have the following formula:
=@WENN(Dashboard!$A$6=Tabelle1!C204;Tabelle1!D192:BD192;NV())
can I delete the @ in the cell (Tabelle1 D202) with VBA.
Problem started as the formula gets insertet automatically via an VBA code
Example:
table1Sheet.range("D210").formula = "=IF(Dashboard!$A$6=Tabelle1!C202,Tabelle1!D198:BD198,NA())"

Excel automatically puts me a @ now in front.

Please can somebody help?
Thank you guys!

 

[Fluff]

Use .Formula2 rather than .Formula