View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
jodleren jodleren is offline
external usenet poster
 
Posts: 49
Default Excel 2007 and macros/functions

Hello

I have a small function, so I can get the name of the present sheet...

It goes:
Function GetSheetName() As String
'ByVal Sheet As Worksheet
GetSheetName = ActiveSheet.Name
End Function

and as formula it is used:
=GetSheetName();

however, that does not work in excel 2007
why?

WBR
Sonnich