How to get the last sheet created in excel?

Help
12

I figured out why it wasn’t working. Somehow when I chose “Insert” between two sheets, the CodeName did not set correctly for it. So still not sure how reliable CodeName is, but it did seem to work.

Note: you can see the CodeName by choosing “View Code”
image

Also,
Mid("Sheet10", 6) will return 10 so there’s no need to take 2 digits like in your edit:
Mid("Sheet100", 6) will also return 100.

Additionally, I still recommend using Invoke VBA with a .vbs file.
The .vbs file will look like this:

image
image702×250 16.7 KB 

Function GetLastCreatedSheet()
    
    Dim lastAddedSheet As Worksheet
    Dim oneSheet As Worksheet
    Set lastAddedSheet = Worksheets(1)
    For Each oneSheet In Worksheets
	If Val(Mid(oneSheet.CodeName, 6)) > Val(Mid(lastAddedSheet.CodeName, 6)) Then
            Set lastAddedSheet = oneSheet
        End If
    Next oneSheet

    GetLastCreatedSheet = lastAddedSheet.Name
  
End Function

Then, in your Workflow, it will look like this:

image
image1280×361 13.9 KB

That’s the way I would do it, but either way should work.

Regards. @Viorica_Marga

5 Likes