Diana

A user-defined function or a worksheet function. I don't know of any
worksheet functions that do that, but here's a userdefined function that
will

Function LastRow(sh As Worksheet) As Long

LastRow = sh.UsedRange(sh.UsedRange.Cells.Count).Row

End Function

If that doesn't seem to answer your question, then reply to this message
with more specifics and I will be happy to help.

--
Dick Kusleika
MVP - Excel
www.dicks-clicks.com
Post all replies to the newsgroup.

"Diana" wrote in message
...
Hello everyone,

This is the third time I post this request. I don't seem
to get any relevant help.

I need a function that would let me know the number of
the last row that is populated with data.

For instance if my default range is A1:D2000 and my
populated Range is A1:D32, the function needs to return
32 as a result.

I appreciate your help
Diana