StringArray BookNames([scope])
StringArray SheetNames([scope, exclamation])

• BookNames() function is used to get all book names.

• SheetNames() function is used to get all sheet names.

• Scope

  • 1 = Current Book (Default for SheetNames)

  • 2 = Current Folder (Default for BookNames)

  • 3 = Folder and Subfolders

  • 4 = Entire Project

• Exclamation

  • Default = 0, no ! at the end

  • 1 means include ! at the end

Tips

This can be used in F(x) to create range string to retrieve values from different sheets. B0 means the last value in col B