Thread: Bold
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] smandula@idirect.com is offline
external usenet poster
 
Posts: 2
Default Bold

How do you make Character "B" Bold

Sub BonusNumbering()
Dim cell As Range
Dim lRow As Long
Dim lColumn As Long
Application.ScreenUpdating = False
For Each cell In _
Range("AW2:AW" & _
Range("AW65536").End(xlUp).Row)
lRow = cell.Row
lColumn = cell.Value + 1
Cells(lRow, lColumn) = "B"
Next 'cell
Application.ScreenUpdating = True
End Sub

With Thanks