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

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

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

I'm struggling here because I can't get your code to run.and I can't work
out how B11:K40 are being populated.

It seems as if B11:K40 are text, but B42 is a number, so how about using
this formula instead

=SUMPRODUCT(--(B11:K40B1))

--
HTH

Bob Phillips

"Micos3" wrote in message
...
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

Sorry, i only see your anwser now, it works.
I just can't make it work to count the values between 2 cells.

Thanks

"Bob Phillips" escreveu:

I'm struggling here because I can't get your code to run.and I can't work
out how B11:K40 are being populated.

It seems as if B11:K40 are text, but B42 is a number, so how about using
this formula instead

=SUMPRODUCT(--(B11:K40B1))

--
HTH

Bob Phillips

"Micos3" wrote in message
...
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

"Micos3" wrote in message
...
Sorry, i only see your anwser now, it works.
I just can't make it work to count the values between 2 cells.

What exactly does that statement mean?