Menu

Application.Caller

Search this Thread

Prev

Previous Post

Next Post

Next

#6

Report Post

Posted to microsoft.public.excel.misc

Marcelo

Posts: n/a

Default

Application.Caller

thanks Ardus, it's works

regards from Brazil

"Ardus Petus" escreveu:

I did not actually enter the formula, but used the function wizard.

enter:
=[PERSONAL.XLS].ThisSheetName()

HTH
--
AP

"Ardus Petus" a Ã©crit dans le message de news:
...
I pasted it in a standard module.

Cheers,
--
AP

"Marcelo" a Ã©crit dans le message de
news: ...
Hi Ardus, its return #name? here.

did you paste the code in a Module or in a class Module

regards
Marcelo

"Ardus Petus" escreveu:

Works by me!

I entered =ThisSheetName() in a cell, it returned Feuil1, which is
exact.

HTH
--
AP

"Marcelo" a Ã©crit dans le message de
news: ...
Hi all,

I am trying to use this Chip Person function, it doesn't work, if I
use
=thissheetname()

Function ThisSheetName() As String
Application.Volatile True
ThisSheetName = Application.Caller.Parent.Name
End Function

who knows why?

regards from Brazil - going to the 6th *
Marcelo

Reply With Quote

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Formula to list unique values	JaneC	Excel Worksheet Functions	4	December 10th 04 12:25 AM
dropdown value from range in other sheet	mango	Excel Worksheet Functions	11	December 2nd 04 03:19 AM

All times are GMT +1. The time now is 06:29 PM.

About Us

"It's about Microsoft Excel"

Contact Us ExcelBanter forum home Privacy Statement