Hi Kevin

An Online Help for Office 2000 is in MSDN so try

http://msdn.microsoft.com/library/default.asp?URL=/library/officedev/odeopg/deovroffice2000visualbasicprogrammersguide.htm

(This should be entered as one line!)

Assuming your formula will activate the cell with the value found, you can simply do

lntest = Application.ActiveCell.Row

what returns a longInt with the row number

HTH
Markus