none
Limit of user defined styles in workbook RRS feed

  • Question

  • Hello,

    what is the maximal count of user defined styles I can add to the style Collection of a workbook

    (property "Styles" of class "Workbook") ?

    tia

      Hendrik Schmieder

    Friday, March 27, 2020 1:11 PM

All replies

  • According to Excel specifications and limits, the maximum number of unique cell formats/styles is 64,000.

    Regards, Hans Vogelaar (http://www.eileenslounge.com)

    Friday, March 27, 2020 2:53 PM
  • But at the same URL

    there's also


    Fill styles

    256

    Line weight and styles

    256

    According to this the Limit woulde be 256.

    Or do I see it wrong ?

    Tuesday, March 31, 2020 11:03 AM
  • I don't think that applies to cell styles, but I have to admit that I don't know what they mean by those limits.

    Regards, Hans Vogelaar (http://www.eileenslounge.com)

    Tuesday, March 31, 2020 11:58 AM