Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007, I write macros in 2003 is 2007 similar for VBA? Pros andcons please | Excel Programming | |||
Excel 2007 macros - how to merge 5 macros together into one | Excel Discussion (Misc queries) | |||
Excel Functions and Macros | Excel Discussion (Misc queries) | |||
excel functions in macros | Excel Programming | |||
Excel: Deleting Macros and Functions | Excel Programming |