METHOD OR DATA MEMBER NOT FOUND 1

[gc1234]

Hi

I've just upgraded to excell 2003 and get the above error on this line

startStockRow = Sheet2.Cells.Find("StartRow", [a1], xlWhole, xlByRows, xlPrevious).Row + 1



does not like Cells call, has it been superceded?

 

[gc1234]

Script out of range after putting Wokrsheet at the front?

startRow = Worksheets("Sheet1").Cells.Find("EAN Code", [a1], xlWhole, xlByRows, xlPrevious).Row

 

[luceze]

You are missing an argument in the find function. Try this:

startRow = [Sheet2].Cells.Find("EAN Code", [a1], xlFormulas, _
xlWhole, xlByRows, xlPrevious).Row + 1

gc1234 is on the right track in that if Excel can not find the search string it will return the subscript out of range error. Use error handling to take care of that.

HTH,
Eric

 

[gc1234]

Thxs

xlFormulas

It worked on 2000

 

[gc1234]

Question, why am i changing my code after upgrading?

 

[luceze]

I'm using 2002 and that is the syntax for the find function. I don't remember about the earlier versions.

Eric