Need VBA code to remove all HTML from a cell

Hi Guys,

I have a problem and need a solution.

I have multiple lines in my spreadsheet where cells have alot of HTML (this is an HTML Template for eBay) What i need to do is remove all the HTML from the cell so that just the plain text is left.
I've tried doing a find and replace using <*> but this doesn't remove everything, there's always bits of HTML left over.

I need something that i can store in my Personal.xlsb so i ca use on any workbook as i have this alot.

Can somebody please help me. Also i could do we having it so if the HTML specifies the text is on the next line down the format stays.

Hope this makes sense.

Thanks in advance.

Instead of trying to "remove" the HTML, I think it might be MUCH easier to search thru the html code and simply find the text you want and then save this text. You would either save the data to a file or save the data to another worksheet tab or whatever. You could then delete the entire html code, after your data is saved.

Same result, of course, but most likely this alternative is easier to accomplish.

As an example, a few days ago I wrote some code to search for old NFL scores at the nfl.com website. To get the scores I had to parse a bunch of html data. All I wanted were the actual scores, of course. I can't even begin to think of how I would have coded it my program to REMOVE the html code. It was much easier to just search that code for the scores I needed.