VBA Code to extract Text btwn ">TEXT<" ?

Originally Posted by Andy Pope

hard to say without seeing what the contexts of the cell are

The code works for the examples you have provided so far

Do you mind running the latest modified code for Input Value:

<h2><span style="text-decoration: underline; color: #ff0000;">GATE VALVE LOCKOUT &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</span></h2> <table border="0" cellspacing="0" cellpadding="0" width="755"> <tbody> <tr> <td width="490" valign="top"> <ul> <li>Virtually indestructible valve covers.</li> <li>Once locked, they rotate freely around the hand wheel &amp; prevent the valve wheel from being turned.</li> <li>The strong polyurethane plastics make them resistant to cracking and abrasion.</li> <li>They are resistant to extreme weather and temperature conditions.</li> <li>Available in&nbsp;<strong>5 sizes ( Red colour )&nbsp;</strong>Other colours are available on request - minimum quantity applicable.</li> <li>3 padlock holes are available in each gate valve lockout device.</li> <li>Different sizes cover most commonly used valve diameters.</li> <li>Withstands temperatures from - 20&deg;F to 200&deg;F</li> <li>Unique knockout center accommodates OS &amp; Y or &ldquo;rising stem&rdquo; valves.</li> <li>Suitable for hasps and padlocks.</li> </ul> <table border="0" cellspacing="0" cellpadding="0" width="435"> <tbody> <tr> <td class="tblHeaderLeft1" colspan="6">&nbsp;&nbsp;&nbsp; <strong>Dimensions</strong></td> </tr> <tr> <td class="tbBlack"><span style="color: #ff0000;">Size</span></td> <td class="tbBlack"><span style="color: #ff0000;">Inside dia (A)</span></td> <td class="tbBlack"><span style="color: #ff0000;">Inside depth.(B)</span></td> <td class="tbBlack"><span style="color: #ff0000;">Outside dia. (C)</span></td> <td class="tbBlack"><span style="color: #ff0000;">Outside height (D)</span></td> </tr> <tr> <td class="tbWhite">25 - 63.5 mm</td> <td class="tbWhite">70 mm</td> <td class="tbWhite">32 mm</td> <td class="tbWhite">76 mm</td> <td class="tbWhite">38 mm</td> </tr> <tr> <td class="tbWhite">63.5 - 127 mm</td> <td class="tbWhite">130 mm</td> <td class="tbWhite">34 mm</td> <td class="tbWhite">140 mm</td> <td class="tbWhite">44 mm</td> </tr> <tr> <td class="tbWhite"><span style="background-color: #ffff00;">127 - 165 mm</span></td> <td class="tbWhite"><span style="background-color: #ffff00;">170 mm</span></td> <td class="tbWhite"><span style="background-color: #ffff00;">41 mm</span></td> <td class="tbWhite"><span style="background-color: #ffff00;">177 mm</span></td> <td class="tbWhite"><span style="background-color: #ffff00;">50 mm</span></td> </tr> <tr> <td class="tbWhite">165 - 254 mm</td> <td class="tbWhite">257 mm</td> <td class="tbWhite">50 mm</td> <td class="tbWhite">267 mm</td> <td class="tbWhite">63 mm</td> </tr> <tr> <td class="tbWhite">254 - 355 mm</td> <td class="tbWhite">355 mm</td> <td class="tbWhite">63 mm</td> <td class="tbWhite">368 mm</td> <td class="tbWhite">74 mm</td> </tr> </tbody> </table> <br /> <table border="0" cellspacing="0" cellpadding="0"> <tbody> <tr> <td class="tblHeaderLeft"><strong>MODEL</strong></td> <td class="tblHeaderRight"><strong>PRODUCT DESCRIPTION</strong></td> </tr> <tr> <td class="tblHeaderLeftcode"><span style="color: #000000;">ES -<strong>&nbsp;02 - GVL</strong></span></td> <td class="tblHeaderRightcode"><span style="color: #000000;">Fits on handle wheel dia from 25 to 63.5 mm ( 1" - 2½" inch)</span></td> </tr> <tr> <td class="tblHeaderLeftcode">ES -<strong>&nbsp;04 - GVL</strong></td> <td class="tblHeaderRightcode">Fits on handle wheel dia from 63.5 to 127 mm ( 2½" - 5" inch)</td> </tr> <tr> <td class="tblHeaderLeftcode"><span style="background-color: #ffff00;">ES -<strong>&nbsp;06 - GVL</strong></span></td> <td class="tblHeaderRightcode"><span style="background-color: #ffff00;">Fits on handle wheel dia from 127 to 165 mm ( 5" - 6½" inch)</span></td> </tr> <tr> <td class="tblHeaderLeftcode">ES -<strong>&nbsp;08 - GVL</strong></td> <td class="tblHeaderRightcode">Fits on handle wheel dia from 165 to 254 mm ( 6½" - 10" inch)</td> </tr> <tr> <td class="tblHeaderLeftcode">ES -<strong>&nbsp;10 - GVL</strong></td> <td class="tblHeaderRightcode">Fits on handle wheel dia from 254 to 355 mm ( 10" - 13" inch)</td> </tr> </tbody> </table> </td> <td width="260" valign="top"><img src="http://www.safetylock.esquare.info/images/valve/valve1.jpg" alt="" width="250" align="right" /></td> </tr> </tbody> </table>