excel macro name sheet Excel Macro Read Sheet Name 15 Aug, 2021 Now to get the list of files we will use the named range within an INDEX function. For i 1 To SheetsCount. How To Se…