[RESOLVED] find repeating value in a row and column

[seenu_1st]

hi experts
i want to find any same value repeat in any other cells of an excel sheet using vb. for example 10 rows 10 column,
kindly reply with some code and suggestions

thanks
with regards
seenu...

[westconn1]

the green tick mark generally indicates a resolved problem, in this forums

you can try like

set r =  range("a1:j10")
for each c in r
    set f = r.find(c.value)
    if not f is nothing then msgbox "cell " & c.address & " matches cell " & f.address
next

[seenu_1st]

hi westconn
thanks for ur reply, i cant understand it well, if posible pls post a simple project in excel, which find the repeated value with in a range of cells

thanks

[westconn1]

put a command button or something, copy that code to work when the button is clicked

change the range to your 10x10 of data
run it and see what happens

[seenu_1st]

yes i did as u told, but it shows all the cells in the msgbox one by one even the value not repeating, like this "cell $A$1 matches cell $A$1" upto the last cell of range(A1 to J10), that means the msgbox shown (10X10=100) times.

[westconn1]

oops, try changing line 3 to
set f = r.find(c.value, c)

[seenu_1st]

sory, resulting the same even after change the code, i think i hav to check the value by row and column then only i can get all the repeating values, i try my best, if u hav any idea pls tel me

[Siddharth Rout]

I thought this thread is resolved

Ok

Here is a quick sample... little complex but works just fine...

Hope this is what you wanted?

[seenu_1st]

thanks kool
yes it is little complex but works fine