find the name of the last excel sheet vb code example Example: find the name of the last excel sheet vb LastSheetName = Sheets(Sheets.Count).Name