Jump to content

Speed ​​up sequence comparison


Recommended Posts

I'm trying to understand just that, the sequences match well, the only thing I can't understand is because my script finds 275 matches and your 235 matches.
A difference of 40 of which 30 are justified by the fact that mine also counts the last 5 half-empty or empty cells but 5 x 6 is 30 so I always miss 10 matches.

Link to comment
Share on other sites

I also tried to write the results inside the excel file but I am missing something to write them sequentially:

_Excel_RangeWrite ($ oWorkbook, $ oWorkbook.Activesheet, "A" & $i + 1 & "-" & "A" & $i + 6 & "/" & "C" & $j + 1 & "-" & " C "& $j + 6,"E" & $j+$SERIAL) ???

excuse my ignorance but how can I comment out the skip? :)

Link to comment
Share on other sites

Ok there is only few differences, you must locate those and see what is right and what is wrong.  But I know my script cannot be wrong cause it is so simple. But then again show me where it is given bad result.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...