2) is there is away to have a bullet at the begining in
multi line cell
1. Adapt the following for multi-colored font in a cell
Sub CellFont()
With ActiveCell.Characters(Start:=1, length:=3).Font
.ColorIndex = 3
.Bold = True
.Underline = True
End With
With ActiveCell.Characters(Start:=4, length:=3).Font
.Superscript = True
.ColorIndex = 5
End With
End Sub
2. Enter a bullet using ALT + 0149(enter via the number pad...not regular
number keys).....Wingdings font yields some interesting bullets.....open Char
Map to view.
HTH Gord Dibben Excel MVP - XL97 SR2
It would be nice, but it can't be done.
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com ch...@cpearson.com
"saleem" <23au...@omantel.net.om> wrote in message
news:372f01c28150$cbdab4f0$2ae2...@phx.gbl...