Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Bold
Range(lRow, lColumn).Select
Selection.Font.Bold = True This will make the text in the cell bold. " wrote: 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Bold
Office Helper
Thanks, works nicely |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Bold
For Each cell In _
Range("A2:A" & Cells(Rows.Count, "a").End(xlUp).Row) With Cells(cell.Row, cell + 1) .Value = "B" .Font.Bold = True End With Next cell === OR ======= For i = 2 To Cells(Rows.Count, "a").End(xlUp).Row With Cells(i, Cells(i, "a") + 1) ..Value = "B" ..Font.Bold = True End With next i -- Don Guillett SalesAid Software wrote in message ups.com... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
macro to bold number of chars from end of a string | Excel Discussion (Misc queries) | |||
use COUNTIF to total BOLD TEXT?? | Excel Worksheet Functions | |||
need to change writing to bold by only typing, not changing cell | Excel Worksheet Functions | |||
Bold a portion of concatenated string | Excel Discussion (Misc queries) | |||
Can I print bold text with unbolded border | Excel Discussion (Misc queries) |