I'm a
VB noob :(
how do i apply this lines in the program in excel?
Isn't there another simpler way? a funcion or something?
If u could tell how to do it i appriciate cos my knowledge of
VB sucks.
Sorry to reply only now but yesterday i didn't saw your awnser.
Thanks again
"Bob Phillips" escreveu:
I think you mean duplicates
If Application.Countif(Range("B11:K40"),Activecell.Va lue) 1 Then
'duplicates
--
HTH
Bob Phillips
"Micos3" wrote in message
...
i don't know what is the problem on the VB and i think it could be managed
in
other way,do u know any command that gives the value in a cell that has
values that aren't readed by the excell?
I once had a similar problem, cos excell didn't read the values of the
cells
but a command that i don't remember, made excell to assume the values and
so
i did the formula.
Do you know any command that does this?
Thanks