Writing excel formula with rangewrite

[Eggie6]

Hi,

I'm trying to write an formula to the excel, but it actually does not write anything into the cell, any ideas?

$formula1="=MID(B"&$utakmice&",SEARCH("-",B"&$utakmice&")-1,1)"
_Excel_RangeWrite($oWorkbook, $oWorkbook.Activesheet, $formula1, "C"&$smth)

 

[Subz]

Try

$formula1="=MID(B"& $utakmice & ',SEARCH("-",B' &$utakmice&")-1,1)"

 

[Eggie6]

1 minute ago, Subz said:

Try

$formula1="=MID(B"& $utakmice & ',SEARCH("-",B' &$utakmice&")-1,1)"

 

Wow....that worked thanks