Is this really hard?
 

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

Is this really hard?
 

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!

Is this really hard?
 

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!