Returns a list of defined names based on a specified scope.
@DefinedNames([<MatchPattern>], [<Scope>], [<ReturnFormat>])
Argument Name | Description |
---|---|
MatchPattern | Enter a regex pattern to match or leave blank for all defined names. https://docs.microsoft.com/en-us/dotnet/standard/base-types/regular-expression-language-quick-reference |
ReturnFormat | "S[imple]", a comma delimited unique list of defined names. "D[etailed]", a row-and-column delimited list of: Unique-Key: If Scope is Workbook or CurrentWorksheet then the key will be the range name, otherwise it will be |
Scope | "W[orkbook]", "A[llWorksheets]", or "C[urrentWorksheet]". Default = "CurrentWorksheet". (case insensitive) |