Functions and macros - calling a UDF

[elprup]

I have an excel file with multiple tabs. I want to have a summary tab a
the beginning that would list the last value in each tab like so:

Sheet2 last value= xxxxxx
Sheet3 last value= xxxxxx
Sheet3 last value= xxxxxx

I found the function to find the REAL last value here:

http://www.beyondtechnology.com/geeks012.shtml

Then it says the LastCell function shown here would not be used in
worksheet, but would be called from another VBA procedure:

Sub Demo ()

MsgBox LastCell(Sheet1).Row

End Sub


I'm a VBA newbie, so I'm stuck at this point. How do I get everythin
to work together in Excel?

While attempting to educate myself, I read that you need to have th
file open that it was created in for things to work properly. Then
found that if you wanted it to work while the file was closed, you ha
to create an Excel add-in.

In summary, I want to be able to create a new tab at any point in an
file and be able to list the last cell value of mulitple tabs (in th
same file) in summary form in the new tab that I inserted. I want to b
able to do it without needing another file open or using the file's nam
that the UDF was created in.

Here's an example file of what I'm looking to accomplish:

http://www.savefile.com/files/9280863


BTW, I'm using Excel 2000

 

[Tom Ogilvy]

the Find method, which is the key element of that procedure, won't work in a
UDF in xl2000.

 

[elprup]

Wouldn't that be why they stated that it would be called from another
VBA procedure?

-Using this Function:

The LastCell function shown here would not be used in a worksheet, but
would be called from another VBA procedure. Implementing it is as
simple as the following example:

Example:

Sub Demo()

MsgBox LastCell(Sheet1).Row

End Sub-


I don't know VBA, but I do possess intelligence. I realize I'm jumping
into VBA at an advanced level, but hey, it's the task at hand that's
forcing me to do so. The situation I need this for is so asinine, it
angers me everytime I think about it . I definitely want to
learn VBA, but at this point I really need to have my hand held through
this so I can get some immediate relief.