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