Mitja BezenšekChief gardener
All categories

Excel.

Excel development tips: exploring the object model, diagnosing bugs, and working around unexpected behavior.

3 articles · Subscribe to this topic

  1. Excel VSTO RGB Color bug

    One of the strangest bugs I found in VSTO for Excel is the one that deals with assigning colors to the RGB property of the ChartFormat object.

  2. Excel's ActivePane Index property bug and a workaround

    A short description of a bug in the Excel object model. The ActivePane Index property does not work according to specification.

  3. The best way to get to know Excel Object Model

    What is the best way to get to know Excel object model? Most likely the macro recorder.