Re: Application.Caller

Tech-Archive recommends: Speed Up your PC by fixing your registry



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




.


Quantcast