Create a Macro to strip out HTML coding from cells in a worksheet

Posted by Brian on September 18, 2001 2:53 PM

Have get a report on a regulr basis that has HTML coding in the header cells of the spreadsheet. Example: Sent to Production

I can't find how to create a macro that removes the HTML coding. Any advice?

BL
(I'm using Excel 2000)

Posted by Tommy on September 18, 2001 5:50 PM

You should be able to get the code from the macro recorder (e.g. Range("A1").Hyperlinks.Delete)