View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Marcelo
 
Posts: n/a
Default Application.Caller

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