Functions and macros - calling a UDF
 

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 he

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 procedu

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

--
elpru
-----------------------------------------------------------------------
elprup's Profile: http://www.excelforum.com/member.php...fo&userid=3401
View this thread: http://www.excelforum.com/showthread.php?threadid=53774

Functions and macros - calling a UDF
 

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

--
Regards,
Tom Ogilvy



"elprup" wrote:


I have an excel file with multiple tabs. I want to have a summary tab at
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 he

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

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

Sub Demo ()

MsgBox LastCell(Sheet1).Row

End Sub


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

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

In summary, I want to be able to create a new tab at any point in any
file and be able to list the last cell value of mulitple tabs (in the
same file) in summary form in the new tab that I inserted. I want to be
able to do it without needing another file open or using the file's name
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.


--
elprup
------------------------------------------------------------------------
elprup's Profile: http://www.excelforum.com/member.php...o&userid=34011
View this thread: http://www.excelforum.com/showthread...hreadid=537746

Functions and macros - calling a UDF
 

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 :mad: . 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.


--
elprup
------------------------------------------------------------------------
elprup's Profile: http://www.excelforum.com/member.php...o&userid=34011
View this thread: http://www.excelforum.com/showthread...hreadid=537746