conditioning 'find'

R

raymondsum

Hello,

I want to write VB to find something if the condition was satified
Actually, I think it is rather simple but i dont know.

e.g. if Cell D1=0, find "A" (this is text and in Cell E10) and goto t
this cell address and delete it.

Regards

Raymon
 
R

raymondsum

Dear Kevin,

Thanks a lot. It works.

I have another request. If I dont want to "Exit Sub", then goto to cel
"A1". How do I change the vb?

Thanks in advance

Raymon
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top