Thread: Creating the name of a worksheet in a cell
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Kari J Keinonen[_2_] Kari J Keinonen[_2_] is offline
external usenet poster
  
Posts: 20
Default Creating the name of a worksheet in a cell
Hi!

Try this one.

Function sht_name()
Application.Volatile True
sht_name = Application.Caller.Parent.Name
End Function

Regards,
Kari J Keinonen
Reply With QuoteReply With Quote