If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Find & Replace in XP
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 |
#2
|
|||
|
|||
Find & Replace in XP
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 |
#3
|
|||
|
|||
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 . |
#4
|
|||
|
|||
Find & Replace in XP
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 In article , says... 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 |
Thread Tools | |
Display Modes | |
|
|