Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
loop to check for duplicates Newbie pls help
I have random program numbers in a cell in each row for example in R4,C4,
406518,417615, 42586. I need to run through all the rows with a loop to check that there are no duplicate numbers in any of the other cells. I need an inner and an outer loop. I have the outer loop I think. I need to compare the first line cell contents and then run through every row to make sure the first program numbers aren't in any other cells. Then I need to proceed to the second line compare those numbers with every other line through the end of the spread sheet ensuring that there are no duplicate program numbers in the 2nd column. Here is all I have so far: Sub ckDups() Range("R1C2").Select Do While ActiveCell.Value < "" ??????????? ActiveCell.Offset(1, 0).Select Loop End Sub thanks very much |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBA Newbie: Help with Do Loop code | Excel Discussion (Misc queries) | |||
VBA Newbie: Help with Do Loop code | Excel Programming | |||
Loop macro for a Newbie | Excel Programming | |||
newbie: stop a FOR NEXT loop | Excel Programming | |||
Newbie. Please help me find a loop solution | Excel Programming |