Jump to content

Recommended Posts

Posted (edited)

Hello

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

Edited by SorryButImaNewbie

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...