Question Rename Excel sheet

[Mulligatawny]

If an excel sheet is not a specific name, is it possible to rename to that specific name.

IE, if the sheet needs to be October but it is Sheet1 or anything else, is it possible to rename the sheet to October.

If not is it possible to retrieve the sheet name before executing the following line

xlWorkSheet = xlWorkBook.Worksheets(SheetName)

Thank You

 

[jmcilhinney]

This question was posted almost a week ago at another site and I was among a few people who responded there and then, so I'm curious as to why you're posting the very same question here. We're happy to help here but it's a waste of our time providing information you already have. Is there something wrong with what you've already been provided with and, if so, what? It comes across as slightly suspect that you have at least a partial solution but you are hiding that fact here.