Find and Replace formatting inside of a macro
 

I have created a macro that will do formatting to a spreadsheet that is
exported from a different program. Inside the macro, I need to do a
find and replace and with the item to be replaced, I want to make the
replacement item bold. In a normal find and replace process, you are
given the option to format what is replaced but while inside the macro,
it is disabled. I don't know how to program Visual Basic and was
wondering if there is a string that I can use to force that formatting
to happen. The formatting needs to be performed if a string contains
certain bits of information, so I need it to scan the spreadsheet and
look for that info and then if it finds it make it bold.


--
mlstjohn
------------------------------------------------------------------------
mlstjohn's Profile: http://www.excelforum.com/member.php...o&userid=16359
View this thread: http://www.excelforum.com/showthread...hreadid=277419