[vba] find

[Karol_tom]

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 ?

 

[Don Guillett Excel MVP]

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."