Select last sheet in wb when sheets are named

[picklefactory]

Hi folks
Trying to find a way to simply select/activate the last sheet in a workbook (Last sheet extreme rh side of tabs, not last sheet used)
Sheets(Sheets.Count).Select doesn't seem to work, being as I am dynamically renaming each sheet as it is created, so I do not have Sheet1, Sheet2 etc.
Is there another way?
Thanks

 

[Peter_SSs]

Wouldn't this be sufficient for selecting the last (visible) sheet?

Sub Select_Last()
  Dim i As Long
  
  i = Sheets.Count
  Do Until Sheets(i).Visible
    i = i - 1
  Loop
  Sheets(i).Select
End Sub

 

[picklefactory]

Thanks Peter, I'll give that a run when I'm back on it in the week. I don't understand any of it, but no change there

 

[Peter_SSs]

I don't understand any of it, ...

It simply says to work from the last worksheet in the workbook back towards the first one and stop & select the first one that you come to that is visible.