Thread
:
Application.Caller
View Single Post
#
7
Posted to microsoft.public.excel.misc
Marcelo
Posts: n/a
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