Thread: [vba] find

Hi,

I want to find in whole column, before I input new entry if something
similar (not exactly the same) exist.

So I think and write:

if (len(name)<6) then
find_Name=name
else
find_name=left(name,6)
end if

I try to use find...but it doesn't work..I don't know why - in my macro I
use find
to check if ID number does not exist before...
I copy this instruction and change only what I'm looking for...
but it doesn't work.. Why ?

On Jul 21, 3:30*pm, "Karol_tom" <Karol_...@wp.pl> wrote:
> Hi,
>
> I want to find in whole column, before I input new entry if something
> similar (not exactly the same) exist.
>
> So I think and write:
>
> if (len(name)<6) then
> find_Name=name
> else
> find_name=left(name,6)
> end if
>
> I try to use find...but it doesn't work..I don't know why - in my macro I
> use find
> to check if ID number does not exist before...
> I copy this instruction and change only what I'm looking for...
> but it doesn't work.. Why ?

"If desired, send your file to dguillett @gmail.com I will only look
if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results."