vba: setting font color to entire sheet

Discussion in 'Microsoft Excel Programming' started by chick-racer, Nov 17, 2003.

  1. chick-racer

    chick-racer Guest

    Hello,

    What i've typed doesnt work, and i'm wondering if i could have advic
    on how to set the entire worksheet to default font color.

    right now i have

    Worksheets(1).font.colorindex=xlautomatic

    what is it supposed to be???

    thanks guys.

    -----------------------------------------------
    ~~ Message posted from http://www.ExcelTip.com
    ~~View and post usenet messages directly from http://www.ExcelForum.com
     
    chick-racer, Nov 17, 2003
    #1
    1. Advertisements

  2. chick-racer

    Chip Pearson Guest

    Re: setting font color to entire sheet

    Try the following to set the ColorIndex of all cells to
    xlColorIndexAutomatic

    ActiveSheet.Cells.Font.ColorIndex = xlColorIndexAutomatic


    --
    Cordially,
    Chip Pearson
    Microsoft MVP - Excel
    Pearson Software Consulting, LLC
    www.cpearson.com



    "chick-racer" <> wrote in message
    news:...
    >
    > Hello,
    >
    > What i've typed doesnt work, and i'm wondering if i could have advice
    > on how to set the entire worksheet to default font color.
    >
    > right now i have
    >
    > Worksheets(1).font.colorindex=xlautomatic
    >
    > what is it supposed to be???
    >
    > thanks guys..
    >
    >
    > ------------------------------------------------
    > ~~ Message posted from http://www.ExcelTip.com/
    > ~~View and post usenet messages directly from http://www.ExcelForum.com/
    >
     
    Chip Pearson, Nov 17, 2003
    #2
    1. Advertisements

  3. chick-racer

    Don Guillett Guest

    Re: setting font color to entire sheet

    try using the sheet name
    Sheets("Sheet4").Cells.Font.ColorIndex = 0

    --
    Don Guillett
    SalesAid Software

    "chick-racer" <> wrote in message
    news:...
    >
    > Hello,
    >
    > What i've typed doesnt work, and i'm wondering if i could have advice
    > on how to set the entire worksheet to default font color.
    >
    > right now i have
    >
    > Worksheets(1).font.colorindex=xlautomatic
    >
    > what is it supposed to be???
    >
    > thanks guys..
    >
    >
    > ------------------------------------------------
    > ~~ Message posted from http://www.ExcelTip.com/
    > ~~View and post usenet messages directly from http://www.ExcelForum.com/
    >
     
    Don Guillett, Nov 17, 2003
    #3
  4. chick-racer

    chick-racer Guest

    chick-racer, Nov 17, 2003
    #4
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Nic@Rolls-Royce

    VBA to copy entire sheet data + formatting

    Nic@Rolls-Royce, Jan 29, 2004, in forum: Microsoft Excel Programming
    Replies:
    3
    Views:
    15,727
    chipsy
    Feb 20, 2007
  2. bertbarndoor
    Replies:
    4
    Views:
    530
    bertbarndoor
    Oct 5, 2007
  3. Guest

    If Font.ColorIndex = 3, Copy Entire Row and Paste to New Sheet

    Guest, Nov 2, 2007, in forum: Microsoft Excel Programming
    Replies:
    3
    Views:
    867
    Guest
    Nov 2, 2007
  4. Russ
    Replies:
    2
    Views:
    233
  5. Ben

    custom color for font color and or background shading color

    Ben, May 4, 2010, in forum: Microsoft Excel Programming
    Replies:
    2
    Views:
    1,277
Loading...

Share This Page