Thread
:
VBA to Find & Delete
View Single Post
#
3
Posted to microsoft.public.excel.programming
Don Guillett[_4_]
external usenet poster
Posts: 2,337
VBA to Find & Delete
a for/each loop should do it
for each c in selection
if c.value="France,Paris" then
next
--
Don Guillett
SalesAid Software
Granite Shoals, TX
"Dave" wrote in message
...
would anybody be able to give me code to do the following;
i have a list of destinations A-Z, with 2 columns of data
in columns B & C
i would like to find specific destination names,
forexample 'France,Paris', and then delete the whole row
which that destination is on. I would then like to repeat
this several times
thanks in advance for any help
Dave
Reply With Quote
Don Guillett[_4_]
View Public Profile
Find all posts by Don Guillett[_4_]