View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Southern at Heart Southern at Heart is offline
external usenet poster
 
Posts: 25
Default vba to convert htm tags

I am needing to use VBA to do this:
Find every cell in my sheet that is bold, and replace it with "^b" plus
whatever text is in the cell, and another "^b"

I also need to do the reverse: find any cell that has ^b in it, and remove
the ^b, and make that cell bold

I've tried figuring this out with the record macro feature, but it doesn't
seem to record some of the find/replace features correctly when working with
finding the bold font.
thanks, southernatheart