Find & Replace in XP
i'll check this out. Thanks.
Is that the only way to get find & replace to replace just
the text that is typed in and not the surrounding
characters. i was so thrilled to see this feature finally
appear in Excel.
-----Original Message-----
Here is PART of what I just recorded. You can adapt to
your needs.
With ActiveCell.Characters(start:=1, Length:=2).Font
' .Name = "Arial"
.FontStyle = "Bold"
' .Size = 10
' .Strikethrough = False
' .Superscript = False
' .Subscript = False
' .OutlineFont = False
' .Shadow = False
' .Underline = xlUnderlineStyleNone
' .ColorIndex = xlAutomatic
End With
--
Don Guillett
SalesAid Software
"Jane" wrote in
message
...
XP now has the ability to do a find & replace based on
formatting, but i ran across an issue. If I type the
word
accountant in cell A1 and "accountants are fun" in cell
A2, do a find and replace for the word accountant that
will bold it. In cell a2 it will bold the entire cell
instead of just the word accountant, is there a way
around
this if you just want the text and not the entire cell
formatted?
Thanks
.
|