Сell comparison in Excel Topic is solved

[inseption86]

Hello guys, tell me how to compare several lines, I can do one line (there are 10 columns), and how to make a cycle, for example, into 5 lines

Code: Select all

loop 10
{
IF xl.workSheets(1).cells(1,A_Index).value != xl.workSheets(2).cells(1,A_Index).value 
{
MsgBox, 4144, , % xl.cells(1,A_Index).value
}
}

[hd0202]

What you need is a loop in loop and the correct use of A_Index:

Code: Select all

loop 5
{
  ind1 := A_Index
  loop 10
  {
      IF xl.workSheets(1).cells(ind1,A_Index).value != xl.workSheets(2).cells(ind1,A_Index).value 
        MsgBox, 4144, , % xl.cells(ind1,A_Index).value
  }
}

Hubert