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

Thank you for the effort but your formula doesn't work.


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

I'm sorry to hear that. I'm sure what you meant to say is that it doesn't
work for your situation, because I tested it and I know it works. If you
like, you can provide more information, particularly what results you are
getting and what results you expect to get. I have no doubt that a suitable
solution can be provided, if not by me, then by someone.

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

"Diana Popovska" wrote in message
...

Thank you for the effort but your formula doesn't work.


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!