Nils_Junker
Board Regular
- Joined
- Jun 2, 2023
- Messages
- 80
- Office Version
- 365
- Platform
- Windows
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!
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!