excel - Variable definition missmatch with WorksheetFunction.Match function -

excel - Variable definition missmatch with WorksheetFunction.Match function -

i'm using below code find match function in vba find transaction id in column:

findrow = application.worksheetfunction.match(cell, _ activeworkbook.sheets(temp_import).range("b:b"), 0)

the transaction id (cell) i'm looking on 63,000th row. i'm wondering if have defined variable findrow incorrectly , preventing match function working? have defined findrow integer.

any pointers appreciated.

define long. xl2007+ supports 1048576 rows.

see this. give error.

sub sample() dim integer = 63000 end sub

now seek this

sub sample() dim long = 63000 end sub

and since using match, either utilize error handling or define variable variant

if search stackoverflow, many posts have been covered on how handle match in vba.

excel vba variables excel-vba match