Find & Replace in XP

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jane - 26 Apr 2004 19:51 GMT

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

Reply to this Message

Don Guillett - 26 Apr 2004 20:25 GMT

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

Signature

Don Guillett
SalesAid Software
donaldb@281.com

> XP now has the ability to do a find & replace based on
> formatting, but i ran across an issue. If I type the word
[quoted text clipped - 6 lines]
>
> Thanks

Reply to this Message

Jane - 26 Apr 2004 20:50 GMT

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.
[quoted text clipped - 24 lines]
>
>.

Reply to this Message

Tushar Mehta - 27 Apr 2004 12:29 GMT

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

Signature

Regards,

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

> XP now has the ability to do a find & replace based on
> formatting, but i ran across an issue. If I type the word
[quoted text clipped - 6 lines]
>
> Thanks

Reply to this Message