Counting Found result from find.

  • Hi, is there a way to count found result from FIND in vba?
    I want a msgbox found count.
    Suppose if there are 278 words called "Ext1" in finding range i want vba to retuen result in msgbox.

    Thanks for helping.

    Pedie

  • Re: Counting Found result from find.


    Hi Ped
    Adjust the rng to your sheets and range and use
    ...

  • Re: Counting Found result from find.


    Thanks alot for replying. THat was great! Can I also mke vba select the last found result and copy it to shee1 range("A1")

    Thanks again

  • Re: Counting Found result from find.


    Hi Ped,
    vba can do that
    If the finds last address doesnt equal the first finds address then it must be the last one

  • Re: Counting Found result from find.


    Pike, thanks again. It was all new for me. Thank you so much you did it!!! Great!!!

    Have a great weekend!
    :)

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!