9 posts in this topic
eWrite How to Bold?
First, I thank you for all the help I received here with Excel UDFs and COM objects in the last few days/week.
I would like to "pimp" my output excel a bit, and for that I would like to write some results Bold.
How do I do that?
I tried a few things but most return errors, or doesn't do a thing seemingly.
My code right now, this does run, but doesn't make the inserted results bold. (by inserted I mean what I write with _Excel_RangeWrite)
_Excel_RangeWrite($ExcelObject, $ExcelObject.Activesheet, "=" & $OSSZEGoszlop & $CellaOlvasoSzamlalo & "*" & String($ArfolyamArray[$DateArrayTimeIndex]) & "", String($sHUFBeszurOszlop) & $CellaOlvasoSzamlalo) $ExcelObject.Activesheet.Range(String($sHUFBeszurOszlop) & $CellaOlvasoSzamlalo).Bold = True Thank you for the help!
Edit: I leave this here, added the bold tag, maybe someone find it usefull