just match a number larger than possible in your column
=MATCH(999999999,nameofotherworksheet!B:B)+1

--
Don Guillett
SalesAid Software

"cvach" wrote in message
oups.com...
I currently have a workbook with two worksheets. I need a formula that
returns the row number from the second worksheet of the first unused
row. I need this value to be displayed in a cell on the first
worksheet.