Hi in Column A Row R8 and below I have portfolios which start with ZI and FI, i need a code that will delete entire row in Col A which has pfolios starting with these 2 letters
<TABLE style="WIDTH: 64pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=85 border=0 x:str><COLGROUP><COL style="WIDTH: 64pt; mso-width-source: userset; mso-width-alt: 3108" width=85><TBODY><TR style="HEIGHT: 12.75pt" height=17><TD class=xl96 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 64pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" width=85 height=17 x:str="ZISJHH"> ZISJHH </TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl96 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17 x:str="FIETRR"> FIETRR </TD></TR></TBODY></TABLE>
<TABLE style="WIDTH: 64pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=85 border=0 x:str><COLGROUP><COL style="WIDTH: 64pt; mso-width-source: userset; mso-width-alt: 3108" width=85><TBODY><TR style="HEIGHT: 12.75pt" height=17><TD class=xl96 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 64pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" width=85 height=17 x:str="ZISJHH"> ZISJHH </TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl96 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17 x:str="FIETRR"> FIETRR </TD></TR></TBODY></TABLE>