tag:blogger.com,1999:blog-28492262.post8958173475981094061..comments2023-12-27T22:22:25.151-08:00Comments on VBA Tips & Tricks: How to Search Bold Text (Range) using Excel VBAUnknownnoreply@blogger.comBlogger5125tag:blogger.com,1999:blog-28492262.post-58962652831391957882012-08-08T12:06:18.993-07:002012-08-08T12:06:18.993-07:00how do i do the same thinig but i would need to fi...how do i do the same thinig but i would need to find specifice bold values within a cell...Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-28492262.post-46790133792372408462009-03-09T05:02:00.000-07:002009-03-09T05:02:00.000-07:00Hi AnonymousYour Macro Code Very Useful Us Thanks...Hi Anonymous<BR/>Your Macro Code Very Useful Us Thanks For Your Valuable Code<BR/>If Any New Easy Code is there Pls Sent me<BR/>I also a Beginners in Excel Macro i want to Your Help<BR/>If you Dont mine pls Visit My Blog www.amudhaExceltips.blogspot.com<BR/>Keep in touch Always <BR/>ThanksExcel Tipshttps://www.blogger.com/profile/11856529736447407500noreply@blogger.comtag:blogger.com,1999:blog-28492262.post-88254962741116393962009-03-05T20:14:00.000-08:002009-03-05T20:14:00.000-08:00This worked for me:Sub Tag_Bold() For Each c In [A...This worked for me:<BR/><BR/>Sub Tag_Bold()<BR/> For Each c In [A1:A10]<BR/> If c.Font.Bold = True Then<BR/> c.Value2 = "-" & c.Value2 & "-"<BR/> End If<BR/> Next<BR/>End Sub<BR/><BR/>seems quite a bit faster...Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-28492262.post-23056224156042553912008-12-30T06:34:00.000-08:002008-12-30T06:34:00.000-08:00We are assigning a Worksheet Range A1:A1000 to the...We are assigning a Worksheet Range A1:A1000 to the Range object<BR/><BR/>Can you try <BR/><BR/>Set oRng = oWS.Range("A1:A1000").Find(What:="", LookIn:=xlValues, LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, SearchFormat:=True) <BR/><BR/>The above should be in single lineM Shasurhttps://www.blogger.com/profile/17390752937266096344noreply@blogger.comtag:blogger.com,1999:blog-28492262.post-5407143101924582792008-12-29T05:30:00.000-08:002008-12-29T05:30:00.000-08:00This is not working error Set Rng what is "o"?Sorr...This is not working error Set Rng what is "o"?<BR/><BR/>Sorry I m not Expert <BR/>explain in detailAnonymousnoreply@blogger.com