Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Application.Caller
Works by me!
I entered =ThisSheetName() in a cell, it returned Feuil1, which is exact. HTH -- AP "Marcelo" a écrit dans le message de news: ... 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Application.Caller
Hi Ardus, its return #name? here.
did you paste the code in a Module or in a class Module regards Marcelo "Ardus Petus" escreveu: Works by me! I entered =ThisSheetName() in a cell, it returned Feuil1, which is exact. HTH -- AP "Marcelo" a écrit dans le message de news: ... 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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Application.Caller
Hi!
Just a comment: why use a macro when you have formula to do the job? When needed, I use the following one: =RIGHT(CELL("filename",A2),LEN(CELL("filename",A2) )-FIND("]",CELL("filename",A2))) -- KR V. "Marcelo" wrote: 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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Application.Caller
I did not actually enter the formula, but used the function wizard.
enter: =[PERSONAL.XLS].ThisSheetName() HTH -- AP "Ardus Petus" a écrit dans le message de news: ... I pasted it in a standard module. Cheers, -- AP "Marcelo" a écrit dans le message de news: ... Hi Ardus, its return #name? here. did you paste the code in a Module or in a class Module regards Marcelo "Ardus Petus" escreveu: Works by me! I entered =ThisSheetName() in a cell, it returned Feuil1, which is exact. HTH -- AP "Marcelo" a écrit dans le message de news: ... 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 |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Application.Caller
thanks Ardus, it's works
regards from Brazil "Ardus Petus" escreveu: I did not actually enter the formula, but used the function wizard. enter: =[PERSONAL.XLS].ThisSheetName() HTH -- AP "Ardus Petus" a écrit dans le message de news: ... I pasted it in a standard module. Cheers, -- AP "Marcelo" a écrit dans le message de news: ... Hi Ardus, its return #name? here. did you paste the code in a Module or in a class Module regards Marcelo "Ardus Petus" escreveu: Works by me! I entered =ThisSheetName() in a cell, it returned Feuil1, which is exact. HTH -- AP "Marcelo" a écrit dans le message de news: ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula to list unique values | Excel Worksheet Functions | |||
dropdown value from range in other sheet | Excel Worksheet Functions |