Get last folder from .subfolder return (folders collection)

[jtdewhurst]

I'm trying to find a way to get the last subfolder in a folder object without out using a “For Each” Loop. It seems to me that if the Folders Collection is stored in the memory so that in can be accessed through iteration, than there has to be a way to simply call one without looping through. I have code that works by looping through, but it takes a long time, and the code it is part of is already going to take a long time to execute. What I really want to do is to use the count function to get the number of folders then call the last folder like an entry in an array.
I’m sorry that this is likely a little confusing and atypical.
Thanks

 

[jtdewhurst]

Yes I tried something like that to no avail. In the end it turned out the input sheet I was being given had the last folder of interest on it.