software

Could some kind soul please advise syntex (macro)for deleting a row if first
3 character of a cell contains quot;FSTquot;
I have some value in column quot;Hquot; which contains value FST,FST1,FST2 and so
on. What i want to do is that if first 3 chracters in column quot;Hquot; has a value
quot;FSTquot; then i want to delete that row.

Thanks in advance

Regards
Jed
try sorting and then deleting. Record a macro if desired.

--
Don Guillett
SalesAid Software

quot;Jedquot; gt; wrote in message
...
gt; Could some kind soul please advise syntex (macro)for deleting a row if
gt; first
gt; 3 character of a cell contains quot;FSTquot;
gt; I have some value in column quot;Hquot; which contains value FST,FST1,FST2 and so
gt; on. What i want to do is that if first 3 chracters in column quot;Hquot; has a
gt; value
gt; quot;FSTquot; then i want to delete that row.
gt;
gt; Thanks in advance
gt;
gt; Regards
gt; Jed
gt;
gt;
Hi Jed,

I don't think you need code. Use AutoFilter and choose Custom. Then from the
drop-down choose Begins with and enter FST you'll limited the displayed data.

Once you've filtered you can simply select and delete the rows.
--
ERR229quot;Jedquot; wrote:

gt; Could some kind soul please advise syntex (macro)for deleting a row if first
gt; 3 character of a cell contains quot;FSTquot;
gt; I have some value in column quot;Hquot; which contains value FST,FST1,FST2 and so
gt; on. What i want to do is that if first 3 chracters in column quot;Hquot; has a value
gt; quot;FSTquot; then i want to delete that row.
gt;
gt; Thanks in advance
gt;
gt; Regards
gt; Jed
gt;
gt;
gt;