Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Max value in Do While counter
I get this code to work for small lists, however, the
real test is on almost 54,000 records and the code crashes when j = 32,767. In a nutshell Col B and Col C have values and are being compared against Col F and Col G (If B=F AND C=G, then H=1) Dim i As Integer Dim j As Integer i = 1 j = 1 Do While Not (IsEmpty(Cells(i, 2))) i = i + 1 Do While Not (IsEmpty(Cells(j, 6))) j = j + 1 If ((Cells(i, 2) = Cells(j, 6)) And (Cells(i, 3) = Cells(j, 7))) Then Cells(j, 8) = "1" Loop j = 1 Loop |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Day counter | Excel Discussion (Misc queries) | |||
1+2+3+4+........... Counter | Excel Discussion (Misc queries) | |||
how do I set up a counter? | Excel Discussion (Misc queries) | |||
counter | Excel Discussion (Misc queries) | |||
Counter | Excel Discussion (Misc queries) |