Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

Items.GetPrevious Method

Office 2007
Returns the previous object in the collection.



expression   A variable that represents an Items object.

Return Value
An Object value that represents the previous object contained by the collection.


It returns Nothing if no previous object exists, for example, if already positioned at the beginning of the collection.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.

Community Additions

© 2015 Microsoft