Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: include font with cell reference

  1. #1
    Guest

    Default

    if i reference a cell (ie =c1), how can i get it to include font and colour without hardcoding that into the cell?

  2. #2
    New Member
    Join Date
    Feb 2002
    Posts
    10
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Here's the code,

    You probably wouldn't need all this detail, just select the bits you want to change.

    Range("D15").Select
    Selection.Font.Bold = True
    With Selection.Font
    .Name = "Book Antiqua"
    .Size = 10
    .Strikethrough = False
    .Superscript = False
    .Subscript = False
    .OutlineFont = False
    .Shadow = False
    .Underline = xlUnderlineStyleNone
    .ColorIndex = 3
    End With

    Range("E19").Select
    End Sub


    John

    [ This Message was edited by: bobeuk on 2002-03-05 10:10 ]

    [ This Message was edited by: bobeuk on 2002-03-05 10:10 ]

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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