Find & Replace in XP

J

Jane

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
 
D

Don Guillett

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
 
J

Jane

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.
 
T

Tushar Mehta

I would like to think it is a bug, but MS might just call it a design
feature. ;-)

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top