View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bob Vance[_2_] Bob Vance[_2_] is offline
external usenet poster
 
Posts: 5
Default Slight adjustment needed

The text I have to format also comes in bold and I want to add to this macro
to make the bold print to normal, Thanks.....
Columns("C:C").Select
Range("C3343").Activate
With Selection.Font
.Size = 8
.Strikethrough = False
.Superscript = False
.Subscript = False
.OutlineFont = False
.Shadow = False
.Underline = xlUnderlineStyleNone
.ColorIndex = xlAutomatic
End With
Columns("D:D").Select
Range("D3343").Activate
With Selection
.HorizontalAlignment = xlRight
.VerticalAlignment = xlBottom
.WrapText = False
.Orientation = 0
.AddIndent = False
.IndentLevel = 0
.ShrinkToFit = False
.ReadingOrder = xlContext
.MergeCells = False
End With
End Sub

--



Thanks in advance.........Bob Vance