The GetLast method returns the last object in the collection. It returns Nothing if no last object exists, for example, if the collection is empty.
Note: To ensure correct operation of the GetFirst, GetLast, GetNext, and GetPrevious methods in a large collection, call GetFirst before calling GetNext on that collection, and call GetLast before calling GetPrevious. To ensure that you are always making the calls on the same collection, create an explicit variable that refers to that collection before entering the loop.
Syntax
Set object = objCollection.GetLast()
object Required. On successful return, represents the last object in the collection.
objCollection Required. The collection object.