Thread
:
Deleting row with specific value
View Single Post
#
2
Posted to microsoft.public.excel.misc
Don Guillett
Posts: n/a
Deleting row with specific value
try sorting and then deleting. Record a macro if desired.
--
Don Guillett
SalesAid Software
"Jed" wrote in message
...
Could some kind soul please advise syntex (macro)for deleting a row if
first
3 character of a cell contains "FST"
I have some value in column "H" which contains value FST,FST1,FST2 and so
on. What i want to do is that if first 3 chracters in column "H" has a
value
"FST" then i want to delete that row.
Thanks in advance
Regards
Jed
Reply With Quote