ActiveCell.FormulaLocal = "=WENN(B " & t & " ="""";Tabelle1!H" & o & ";"""")"
t und o sind meine Variabeln. Was mach ich falsch?
Sub test()
Dim t As Long
Dim o As Long
t = 5
o = 5
ActiveCell.FormulaLocal = "=WENN(B" & t & "="""";Tabelle1!H" & o & ";"""")"
End Sub