Сell comparison in Excel Topic is solved

Get help with using AutoHotkey and its commands and hotkeys
inseption86
Posts: 96
Joined: 19 Apr 2018, 00:24

Сell comparison in Excel

30 Jul 2019, 08:53

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
Posts: 163
Joined: 04 Oct 2013, 03:07
Location: Germany near Cologne

Re: Сell comparison in Excel  Topic is solved

30 Jul 2019, 10:39

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

Return to “Ask For Help”

Who is online

Users browsing this forum: Aaron0824, Bing [Bot], magnus, RubbeH and 44 guests