Search a large excel file

[Andrew]

Excellent! I was going to repost because I was having probs again but your latest code appears to work like a charm.

Thanks again!

[Andrew]

One (hopefully) last novice question which I'll ask here for lack of a better place (no sense in starting a new topic):

I am writing my array of cell data to another excel spreadsheet. Because I am doing multiple searches, I am writing multiple arrays, but they all begin at cell position 1,1.

I need a way to tell autoit to begin at the next available 'x' cell position, and I haven't found anything in the help file or this forum that suggests this.

Sorry, I know this must be very simple and I hate to waste your time...

Thanks!

[PsaltyDS]

If what you are looking for is the last used row in the sheet, so you know where to add data, try these methods:

#include <Excel.au3>

Global CONST $xlUp = -4162

Global $oExcel = _ExcelBookAttach(@ScriptDir & "\Test1.xls")

$iLastRow = $oExcel.ActiveSheet.UsedRange.Rows.Count ; last row in any column
ConsoleWrite("$iLastRow = " & $iLastRow & @LF)

$iLastRow = $oExcel.ActiveSheet.Range("B65535").End($xlUp).Row ; last row column 'B'
ConsoleWrite("$iLastRow = " & $iLastRow & @LF)