Re: Application.Caller
- From: "Ardus Petus" <ardus.petus@xxxxxxxxxxx>
- Date: Fri, 23 Jun 2006 15:28:53 +0200
Works by me!
I entered =ThisSheetName() in a cell, it returned Feuil1, which is exact.
HTH
--
AP
"Marcelo" <Marcelo@xxxxxxxxxxxxxxxxxxxxxxxxx> a écrit dans le message de
news: DBE75BE9-A2B7-4C87-A7D2-EF3E8148A6CD@xxxxxxxxxxxxxxxx
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
.
- Prev by Date: Re: A questions of versions
- Next by Date: Re: Filling in missing data
- Previous by thread: Re: Graphing data with compliance limit
- Next by thread: Re: Application.Caller
- Index(es):