+ Reply to Thread
Results 1 to 2 of 2

Error: Unable to set the Size property of the font class

  1. #1
    Forum Contributor
    Join Date
    03-14-2005
    Posts
    164

    Error: Unable to set the Size property of the font class

    hi all,

    I have some VBA that generates pie charts or copies pastes a table of values (Depending on the selection from some comboboxes)

    randomnly when it is generating one of the pies it reutrns:
    run time error '1004'
    Unable to set the Size property of the font class.

    It is when I am running this code:
    Please Login or Register  to view this content.

    and highlights the .Size = 8 row.

    I can run it several times without a problem, and then suddenly it will throw up this error.
    can anybody suggest why it does this?
    Last edited by matpj; 05-29-2007 at 05:06 AM.

  2. #2
    Valued Forum Contributor
    Join Date
    12-16-2004
    Location
    Canada, Quebec
    Posts
    363
    Check this article, will explain why and provide a workaround
    http://support.microsoft.com/kb/832166
    Denis

    Please always attach the sample workbook without sensitive information when asking for help

    To add a module
    Press Alt + F11 (this is the Visual Basic Environment)
    Insert Menu, select Module
    Past code there
    Close Visual Basic Environment (X)

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1